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 836: ,per_all_assignments_f as1

832: ,act.assignment_action_id run_action_id
833: ,act.tax_unit_id legal_employer_id
834: FROM pay_payroll_actions appa
835: ,pay_assignment_actions act
836: ,per_all_assignments_f as1
837: ,pay_payroll_actions ppa
838: WHERE ppa.payroll_action_id = p_payroll_action_id
839: AND appa.effective_date BETWEEN l_canonical_start_date
840: AND l_canonical_end_date

Line 955: FROM per_all_assignments_f paa

951: SELECT paa.assignment_id
952: ,paa.effective_start_date
953: ,paa.effective_end_date
954: ,scl.segment2
955: FROM per_all_assignments_f paa
956: ,hr_soft_coding_keyflex scl
957: WHERE person_id = csr_v_person_id
958: AND paa.effective_start_date <= g_income_end_date
959: AND paa.effective_end_date > = g_income_start_date

Line 1896: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1892: l_eit_local_unit NUMBER;
1893: l_legal_employer_id_fetched NUMBER;
1894: -- Temp needed Variables
1895: l_person_id per_all_people_f.person_id%TYPE;
1896: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1897:
1898: -- Temp needed Variables
1899:
1900: -- End of place for Variables which fetches the values to be archived

Line 1912: FROM per_all_assignments_f paa

1908: SELECT *
1909: FROM (SELECT paa.effective_start_date,paa.effective_end_date
1910: ,paa.person_id
1911: ,paa.assignment_id
1912: FROM per_all_assignments_f paa
1913: ,pay_assignment_actions pac
1914: WHERE pac.assignment_action_id = p_asg_act_id
1915: AND paa.assignment_id = pac.assignment_id
1916: AND paa.effective_start_date <= g_income_end_date

Line 2003: FROM per_all_assignments_f paa

1999: )
2000: IS
2001: SELECT MIN (paa.effective_start_date) effective_start_date
2002: ,MAX (paa.effective_end_date) effective_end_date
2003: FROM per_all_assignments_f paa
2004: ,hr_soft_coding_keyflex scl
2005: WHERE person_id = csr_v_person_id
2006: AND paa.effective_start_date <= g_income_end_date
2007: AND paa.effective_end_date > = g_income_start_date

Line 2054: FROM per_all_assignments_f paa

2050: CURSOR csr_get_segment2 (csr_v_effective_date DATE)
2051: IS
2052: SELECT scl.segment2
2053: ,scl.segment8
2054: FROM per_all_assignments_f paa
2055: ,hr_soft_coding_keyflex scl
2056: ,pay_assignment_actions pasa
2057: WHERE pasa.assignment_action_id = p_assignment_action_id
2058: AND pasa.assignment_id = paa.assignment_id

Line 2114: FROM per_all_assignments_f paa

2110: SELECT paa.assignment_id
2111: ,paa.effective_start_date
2112: ,paa.effective_end_date
2113: ,scl.segment2
2114: FROM per_all_assignments_f paa
2115: ,hr_soft_coding_keyflex scl
2116: WHERE paa.person_id = csr_v_person_id
2117: AND paa.effective_start_date <= g_income_end_date
2118: AND paa.effective_end_date > = g_income_start_date

Line 2139: FROM per_all_assignments_f paa

2135: SELECT paa.assignment_id
2136: ,paa.effective_start_date
2137: ,paa.effective_end_date
2138: ,scl.segment2
2139: FROM per_all_assignments_f paa
2140: ,hr_soft_coding_keyflex scl
2141: WHERE person_id = csr_v_person_id
2142: AND paa.effective_start_date <= g_income_end_date
2143: AND paa.effective_end_date > = g_income_start_date

Line 2234: , per_all_assignments_f paa

2230: ,csr_v_person_id NUMBER
2231: ) is
2232: SELECT count('Y') VALID
2233: from pay_element_entries_f pee
2234: , per_all_assignments_f paa
2235: , pay_element_entry_values_f peev
2236: where peev.screen_entry_value ='A'
2237: AND peev.element_entry_id = pee.element_entry_id
2238: AND peev.input_value_id = csr_v_input_value_id