APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 430: ,hr_soft_coding_keyflex sck

426: ,p_payroll_id NUMBER) IS
427: SELECT paf.assignment_id assignment_id,
428: leg.organization_id legal_employer
429: FROM per_all_assignments_f paf
430: ,hr_soft_coding_keyflex sck
431: ,hr_organization_information wcr
432: ,hr_organization_information leg
433: WHERE paf.effective_start_date = (SELECT max (paf1.effective_start_date)
434: FROM per_all_assignments_f paf1

Line 768: FROM hr_soft_coding_keyflex sck

764: AND pap.effective_end_date;
765: --
766: CURSOR csr_get_contribution_group(c_soft_coding_keyflex_id NUMBER) IS
767: SELECT nvl(sck.segment5,'X') contribution_group
768: FROM hr_soft_coding_keyflex sck
769: WHERE sck.soft_coding_keyflex_id = c_soft_coding_keyflex_id;
770: --
771: CURSOR csr_get_element_values (c_assignment_id NUMBER,c_effective_start_date VARCHAR2) IS
772: SELECT pee.assignment_id AS assignment_Id

Line 819: l_soft_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;

815: l_epi_value pay_element_entry_values_f.screen_entry_value%TYPE;
816: l_unused_number NUMBER;
817: sql_str VARCHAR2(4000);
818: l_ec_value VARCHAR2(60);
819: l_soft_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
820: l_under_repres_women pay_element_entry_values_f.screen_entry_value%TYPE;
821: l_rehired_disabled pay_element_entry_values_f.screen_entry_value%TYPE;
822: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;
823: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;

Line 1052: ,hr_soft_coding_keyflex sck

1048: ,pap.date_of_birth date_of_birth
1049: ,pap.sex sex
1050: from per_all_assignments_f paa
1051: ,per_all_people_f pap
1052: ,hr_soft_coding_keyflex sck
1053: where paa.assignment_id = '||p_assignment_id||'
1054: and paa.person_id = pap.person_id
1055: and paa.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
1056: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_effective_end_date) ||''')

Line 1641: ,hr_soft_coding_keyflex sck

1637: l_unused_number := 0;
1638: SELECT count(sck.segment5), min(paa.effective_start_date)
1639: INTO l_unused_number, l_effective_start_date
1640: FROM per_all_assignments_f paa
1641: ,hr_soft_coding_keyflex sck
1642: WHERE nvl(sck.segment5,'X') <> nvl(l_contribution_group,'X')
1643: AND paa.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
1644: AND paa.effective_start_date >= qualifying_assignments.current_reporting_date
1645: AND paa.assignment_id = qualifying_assignments.assignment_id;

Line 1796: ,hr_soft_coding_keyflex sck

1792: l_unused_number := 0;
1793: SELECT count(sck.segment5), min(paa.effective_start_date)
1794: INTO l_unused_number, l_effective_start_date
1795: FROM per_all_assignments_f paa
1796: ,hr_soft_coding_keyflex sck
1797: WHERE nvl(sck.segment5, 'X') <> nvl(l_contribution_group, 'X')
1798: AND paa.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
1799: AND paa.effective_start_date >= qualifying_assignments.current_reporting_date
1800: AND paa.assignment_id = qualifying_assignments.assignment_id;