APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_COST_ALLOCATIONS_V

Line 1394: FROM pay_cost_allocations_v

1390: -------------
1391: /* Cursor to retrieve Cost Center */
1392: CURSOR csr_cost_center(p_assignment_id NUMBER) IS
1393: SELECT concatenated_segments
1394: FROM pay_cost_allocations_v
1395: WHERE assignment_id=p_assignment_id
1396: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
1397: -------------
1398: /* Cursor to pick up Payroll Location */

Line 1486: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;

1482: l_legal_employer_id hr_organization_units.organization_id%TYPE;
1483: l_job PER_JOBS.NAME%TYPE;
1484: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1485: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1486: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;
1487: l_defined_balance_id NUMBER;
1488: l_balance_value NUMBER;
1489: l_formatted_value VARCHAR2(50) := NULL;
1490: l_org_exists NUMBER :=0;