APPS.PAY_AE_CHEQUE_REPORT dependencies on PAY_PAYROLL_ACTIONS

Line 60: FROM pay_payroll_actions

56:
57: /* Cursor to fetch date_earned for the payroll action */
58: CURSOR csr_get_DE (l_pact_id number) IS
59: SELECT nvl(date_earned,effective_date)
60: FROM pay_payroll_actions
61: WHERE payroll_action_id = l_pact_id;
62:
63: /* Cursor to fetch payroll_name for the payroll action */
64: CURSOR csr_get_PY (l_pact_id number) IS

Line 66: FROM pay_all_payrolls_f pap, pay_payroll_actions ppa

62:
63: /* Cursor to fetch payroll_name for the payroll action */
64: CURSOR csr_get_PY (l_pact_id number) IS
65: SELECT payroll_name
66: FROM pay_all_payrolls_f pap, pay_payroll_actions ppa
67: WHERE ppa.payroll_action_id = l_pact_id
68: AND ppa.payroll_id = pap.payroll_id;
69:
70:

Line 81: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

77: from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou, per_all_people_f ppf
78: where paa.payroll_action_id = p_pact_id
79: and paa.action_status = 'C'
80: and not exists ( select 1
81: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
82: where lck.locked_action_id = paa.assignment_action_id
83: and lck.locking_action_id = paa1.assignment_action_id
84: and ppa1.payroll_action_id = paa1.payroll_action_id
85: and ppa1.action_type = 'D'

Line 110: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

106: from pay_assignment_actions paa , per_all_assignments_f paf, per_all_people_f ppf
107: where paa.payroll_action_id = p_pact_id
108: and paa.action_status = 'C'
109: and not exists ( select 1
110: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
111: where lck.locked_action_id = paa.assignment_action_id
112: and lck.locking_action_id = paa1.assignment_action_id
113: and ppa1.payroll_action_id = paa1.payroll_action_id
114: and ppa1.action_type = 'D'

Line 132: from pay_assignment_actions paa , pay_payroll_actions ppa , pay_pre_payments ppp , pay_assignment_actions paa1,

128: /* Cursor for fetching assignment action id and assignment id for current payroll action id order by payment date*/
129:
130: CURSOR csr_get_assact_det_PD (l_pact_id number,l_date date) IS
131: select paa.assignment_action_id , paa.assignment_id
132: from pay_assignment_actions paa , pay_payroll_actions ppa , pay_pre_payments ppp , pay_assignment_actions paa1,
133: per_all_people_f ppf, per_all_assignments_f paf
134: where paa.payroll_action_id = p_pact_id
135: and paa.action_status IN ('C','S')
136: and not exists ( select 1

Line 137: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

133: per_all_people_f ppf, per_all_assignments_f paf
134: where paa.payroll_action_id = p_pact_id
135: and paa.action_status IN ('C','S')
136: and not exists ( select 1
137: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
138: where lck.locked_action_id = paa.assignment_action_id
139: and lck.locking_action_id = paa1.assignment_action_id
140: and ppa1.payroll_action_id = paa1.payroll_action_id
141: and ppa1.action_type = 'D'

Line 215: from pay_payroll_actions ppa, pay_assignment_actions paa, pay_pre_payments ppp, pay_assignment_actions paa1

211: /* Cursor for fetching the payment date of the pre payment for cheques */
212:
213: CURSOR csr_pay_date (l_assact_id number) IS
214: select nvl(ppa.date_earned,ppa.effective_date)
215: from pay_payroll_actions ppa, pay_assignment_actions paa, pay_pre_payments ppp, pay_assignment_actions paa1
216: where paa.assignment_action_id = l_assact_id
217: and paa.action_status IN ('C','S')
218: and paa.pre_payment_id = ppp.pre_payment_id
219: and ppp.assignment_action_id = paa1.assignment_action_id