APPS.HR_ORU_BUS dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 659: -- PAY_COST_ALLOCATION_KEYFLEX table when not null.

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

Line 697: FROM pay_cost_allocation_keyflex pcak,

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