APPS.PAY_AE_ARCHIVE dependencies on PAY_COST_ALLOCATIONS_V

Line 982: FROM pay_cost_allocations_v

978:
979: /* Cursor to retrieve Cost Center */
980: CURSOR csr_cost_center(p_assignment_id NUMBER) IS
981: SELECT concatenated_segments
982: FROM pay_cost_allocations_v
983: WHERE assignment_id=p_assignment_id
984: AND p_date_earned BETWEEN effective_start_date
985: AND effective_end_date;
986:

Line 1011: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;

1007: l_bg_id NUMBER;
1008: l_employer_name hr_organization_units.name%TYPE;
1009: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1010: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1011: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;
1012: l_defined_balance_id NUMBER;
1013: l_balance_value NUMBER;
1014: l_defined_balance_id_ded NUMBER;
1015: l_balance_value_ded NUMBER;