APPS.PAY_IN_PF_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 328: l_eps HR_SOFT_CODING_KEYFLEX.SEGMENT12%TYPE;

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

Line 345: hr_soft_coding_keyflex scl

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

Line 1367: FROM hr_soft_coding_keyflex scl

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

Line 1403: FROM hr_soft_coding_keyflex scl

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

Line 1452: FROM hr_soft_coding_keyflex scl

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

Line 1509: FROM hr_soft_coding_keyflex scl

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

Line 1993: hr_soft_coding_keyflex scl

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