APPS.PAY_IN_PF_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 330: l_eps HR_SOFT_CODING_KEYFLEX.SEGMENT12%TYPE;

326: l_emp_type VARCHAR2(2);
327: l_term_date DATE ;
328: l_report PER_PERIODS_OF_SERVICE.PDS_INFORMATION1%TYPE;
329: l_efile PER_PERIODS_OF_SERVICE.PDS_INFORMATION2%TYPE;
330: l_eps HR_SOFT_CODING_KEYFLEX.SEGMENT12%TYPE;
331: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;
332:
333: CURSOR csr_pf_people IS
334: SELECT

Line 347: hr_soft_coding_keyflex scl

343: FROM per_people_f ppf,
344: per_person_types ppt,
345: per_assignments_f paf,
346: per_periods_of_service pps,
347: hr_soft_coding_keyflex scl
348: WHERE paf.person_id = ppf.person_id
349: AND paf.period_of_service_id = pps.period_of_service_id
350: AND ppf.person_type_id = ppt.person_type_id
351: AND paf.assignment_id = p_assignment_id

Line 1371: FROM hr_soft_coding_keyflex scl

1367: AND hoi.org_information10 IS NOT NULL
1368: AND hoi.org_information9 IS NOT NULL
1369: AND TO_CHAR (hoi.organization_id) IN
1370: (SELECT scl.segment2
1371: FROM hr_soft_coding_keyflex scl
1372: WHERE scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
1373: AND scl.enabled_flag = 'Y');
1374:
1375:

Line 1407: FROM hr_soft_coding_keyflex scl

1403: AND hoi.org_information10 IS NOT NULL
1404: AND hoi.org_information9 IS NOT NULL
1405: AND TO_CHAR (hoi.organization_id) IN
1406: (SELECT scl.segment2
1407: FROM hr_soft_coding_keyflex scl
1408: WHERE scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
1409: AND scl.enabled_flag = 'Y')
1410: AND NOT EXISTS ( SELECT paa.assignment_id
1411: FROM pay_assignment_actions paa

Line 1456: FROM hr_soft_coding_keyflex scl

1452: AND hoi.org_information10 IS NOT NULL
1453: AND hoi.org_information9 IS NOT NULL
1454: AND TO_CHAR (hoi.organization_id) IN
1455: (SELECT scl.segment2
1456: FROM hr_soft_coding_keyflex scl
1457: WHERE scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
1458: AND scl.enabled_flag = 'Y')
1459: AND NOT EXISTS ( SELECT paa.assignment_id
1460: FROM pay_assignment_actions paa

Line 1513: FROM hr_soft_coding_keyflex scl

1509: AND hoi.org_information10 IS NOT NULL
1510: AND hoi.org_information9 IS NOT NULL
1511: AND TO_CHAR (hoi.organization_id) IN
1512: (SELECT scl.segment2
1513: FROM hr_soft_coding_keyflex scl
1514: WHERE scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
1515: AND scl.enabled_flag = 'Y');
1516:
1517:

Line 1997: hr_soft_coding_keyflex scl

1993: p_assignment NUMBER )
1994: IS
1995: SELECT 1
1996: FROM per_assignments_f paf,
1997: hr_soft_coding_keyflex scl
1998: WHERE (to_char(paf.effective_start_date,'Month-YYYY')=to_char(g_end_date,'Month-YYYY')
1999: OR to_char(paf.effective_end_date,'Month-YYYY')=to_char(g_end_date,'Month-YYYY')
2000: OR g_end_date between paf.effective_start_date and paf.effective_end_date)
2001: AND scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id