APPS.HR_ORU_BUS dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 658: -- PAY_COST_ALLOCATION_KEYFLEX table when not null.

654: -- ----------------------------------------------------------------------------
655: --
656: -- Description:
657: -- Validates that cost_allocation_keyflex_id of organization unit is present in
658: -- PAY_COST_ALLOCATION_KEYFLEX table when not null.
659: --
660: -- Pre-conditions:
661: -- None.
662: --

Line 696: FROM pay_cost_allocation_keyflex pcak,

692: l_exists VARCHAR2(1) := 'N';
693: --
694: CURSOR csr_cost_allocation_keyflex_id IS
695: SELECT 'Y'
696: FROM pay_cost_allocation_keyflex pcak,
697: per_business_groups_perf pbg
698: WHERE pcak.cost_allocation_keyflex_id = p_cost_allocation_keyflex_id
699: AND pbg.business_group_id = p_business_group_id
700: AND pbg.cost_allocation_structure = to_char(pcak.id_flex_num);