APPS.PAY_ES_CALC_SS_EARNINGS dependencies on PER_ALL_ASSIGNMENTS_F

Line 109: ,per_all_assignments_f paaf

105: --
106: CURSOR csr_get_emp_gender IS
107: SELECT papf.sex
108: FROM per_all_people_f papf
109: ,per_all_assignments_f paaf
110: WHERE paaf.assignment_id = p_assignment_id
111: AND papf.person_id = paaf.person_id
112: AND p_date_earned BETWEEN paaf.effective_start_date
113: AND paaf.effective_end_date

Line 241: ,per_all_assignments_f paaf

237: --
238: CURSOR c_contact_info IS
239: SELECT COUNT(pcr.contact_type)
240: FROM per_contact_relationships pcr
241: ,per_all_assignments_f paaf
242: WHERE paaf.assignment_id = passignment_id
243: AND pcr.person_id = paaf.person_id
244: AND pcr.rltd_per_rsds_w_dsgntr_flag = 'Y'
245: AND pcr.cont_information_category = 'ES'

Line 1097: ,per_all_assignments_f paaf1

1093: ,ppa.action_type action_type
1094: ,paa2.assignment_action_id assignment_action_id
1095: FROM pay_assignment_actions paa1
1096: ,pay_assignment_actions paa2
1097: ,per_all_assignments_f paaf1
1098: ,per_all_assignments_f paaf2
1099: ,pay_payroll_actions ppa
1100: ,pay_payroll_actions ppa1
1101: ,per_time_period_types ptpt

Line 1098: ,per_all_assignments_f paaf2

1094: ,paa2.assignment_action_id assignment_action_id
1095: FROM pay_assignment_actions paa1
1096: ,pay_assignment_actions paa2
1097: ,per_all_assignments_f paaf1
1098: ,per_all_assignments_f paaf2
1099: ,pay_payroll_actions ppa
1100: ,pay_payroll_actions ppa1
1101: ,per_time_period_types ptpt
1102: ,per_time_periods ptp

Line 1130: ,per_all_assignments_f paaf1

1126: ,paa2.assignment_action_id assignment_action_id
1127: ,ppa.action_type action_type
1128: FROM pay_assignment_actions paa1
1129: ,pay_assignment_actions paa2
1130: ,per_all_assignments_f paaf1
1131: ,per_all_assignments_f paaf2
1132: ,pay_payroll_actions ppa
1133: ,per_time_periods ptp
1134: WHERE paa1.assignment_action_id = c_assignment_action_id

Line 1131: ,per_all_assignments_f paaf2

1127: ,ppa.action_type action_type
1128: FROM pay_assignment_actions paa1
1129: ,pay_assignment_actions paa2
1130: ,per_all_assignments_f paaf1
1131: ,per_all_assignments_f paaf2
1132: ,pay_payroll_actions ppa
1133: ,per_time_periods ptp
1134: WHERE paa1.assignment_action_id = c_assignment_action_id
1135: AND paa1.assignment_id = paaf1.assignment_id