APPS.PAY_SE_INCOME_STATEMENT dependencies on PER_ALL_ASSIGNMENTS_F

Line 246: ,per_all_assignments_f as1

242: IS
243: SELECT '1'
244: FROM pay_payroll_actions appa
245: ,pay_assignment_actions act
246: ,per_all_assignments_f as1
247: ,pay_payroll_actions ppa
248: WHERE ppa.payroll_action_id = p_payroll_action_id
249: AND appa.effective_date BETWEEN csr_v_canonical_start_date
250: AND csr_v_canonical_end_date

Line 842: ,per_all_assignments_f as1

838: ,act.assignment_action_id run_action_id
839: ,act.tax_unit_id legal_employer_id
840: FROM pay_payroll_actions appa
841: ,pay_assignment_actions act
842: ,per_all_assignments_f as1
843: ,pay_payroll_actions ppa
844: WHERE ppa.payroll_action_id = p_payroll_action_id
845: AND appa.effective_date BETWEEN l_canonical_start_date
846: AND l_canonical_end_date

Line 961: FROM per_all_assignments_f paa

957: SELECT paa.assignment_id
958: ,paa.effective_start_date
959: ,paa.effective_end_date
960: ,scl.segment2
961: FROM per_all_assignments_f paa
962: ,hr_soft_coding_keyflex scl
963: WHERE person_id = csr_v_person_id
964: AND paa.effective_start_date <= g_income_end_date
965: AND paa.effective_end_date > = g_income_start_date

Line 1910: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1906: l_eit_local_unit NUMBER;
1907: l_legal_employer_id_fetched NUMBER;
1908: -- Temp needed Variables
1909: l_person_id per_all_people_f.person_id%TYPE;
1910: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1911:
1912: -- Temp needed Variables
1913:
1914: -- End of place for Variables which fetches the values to be archived

Line 1926: FROM per_all_assignments_f paa

1922: SELECT *
1923: FROM (SELECT paa.effective_start_date,paa.effective_end_date
1924: ,paa.person_id
1925: ,paa.assignment_id
1926: FROM per_all_assignments_f paa
1927: ,pay_assignment_actions pac
1928: WHERE pac.assignment_action_id = p_asg_act_id
1929: AND paa.assignment_id = pac.assignment_id
1930: AND paa.effective_start_date <= g_income_end_date

Line 2018: FROM per_all_assignments_f paa

2014: )
2015: IS
2016: SELECT MIN (paa.effective_start_date) effective_start_date
2017: ,MAX (paa.effective_end_date) effective_end_date
2018: FROM per_all_assignments_f paa
2019: ,hr_soft_coding_keyflex scl
2020: WHERE person_id = csr_v_person_id
2021: AND paa.effective_start_date <= g_income_end_date
2022: AND paa.effective_end_date > = g_income_start_date

Line 2069: FROM per_all_assignments_f paa

2065: CURSOR csr_get_segment2 (csr_v_effective_date DATE)
2066: IS
2067: SELECT scl.segment2
2068: ,scl.segment8
2069: FROM per_all_assignments_f paa
2070: ,hr_soft_coding_keyflex scl
2071: ,pay_assignment_actions pasa
2072: WHERE pasa.assignment_action_id = p_assignment_action_id
2073: AND pasa.assignment_id = paa.assignment_id

Line 2129: FROM per_all_assignments_f paa

2125: SELECT paa.assignment_id
2126: ,paa.effective_start_date
2127: ,paa.effective_end_date
2128: ,scl.segment2
2129: FROM per_all_assignments_f paa
2130: ,hr_soft_coding_keyflex scl
2131: WHERE paa.person_id = csr_v_person_id
2132: AND paa.effective_start_date <= g_income_end_date
2133: AND paa.effective_end_date > = g_income_start_date

Line 2154: FROM per_all_assignments_f paa

2150: SELECT paa.assignment_id
2151: ,paa.effective_start_date
2152: ,paa.effective_end_date
2153: ,scl.segment2
2154: FROM per_all_assignments_f paa
2155: ,hr_soft_coding_keyflex scl
2156: WHERE person_id = csr_v_person_id
2157: AND paa.effective_start_date <= g_income_end_date
2158: AND paa.effective_end_date > = g_income_start_date

Line 2249: , per_all_assignments_f paa

2245: ,csr_v_person_id NUMBER
2246: ) is
2247: SELECT count('Y') VALID
2248: from pay_element_entries_f pee
2249: , per_all_assignments_f paa
2250: , pay_element_entry_values_f peev
2251: where peev.screen_entry_value ='A'
2252: AND peev.element_entry_id = pee.element_entry_id
2253: AND peev.input_value_id = csr_v_input_value_id