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 106: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

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

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

120: /* Cursor for fetching assignment action id and assignment id for current payroll action id order by payment date*/
121:
122: CURSOR csr_get_assact_det_PD (l_pact_id number,l_date date) IS
123: select paa.assignment_action_id , paa.assignment_id
124: from pay_assignment_actions paa , pay_payroll_actions ppa , pay_pre_payments ppp , pay_assignment_actions paa1,
125: per_all_people_f ppf, per_all_assignments_f paf
126: where paa.payroll_action_id = p_pact_id
127: and paa.action_status = 'C'
128: and not exists ( select 1

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

125: per_all_people_f ppf, per_all_assignments_f paf
126: where paa.payroll_action_id = p_pact_id
127: and paa.action_status = 'C'
128: and not exists ( select 1
129: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
130: where lck.locked_action_id = paa.assignment_action_id
131: and lck.locking_action_id = paa1.assignment_action_id
132: and ppa1.payroll_action_id = paa1.payroll_action_id
133: and ppa1.action_type = 'D'

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

195: /* Cursor for fetching the payment date of the pre payment for cheques */
196:
197: CURSOR csr_pay_date (l_assact_id number) IS
198: select nvl(ppa.date_earned,ppa.effective_date)
199: from pay_payroll_actions ppa, pay_assignment_actions paa, pay_pre_payments ppp, pay_assignment_actions paa1
200: where paa.assignment_action_id = l_assact_id
201: and paa.action_status = 'C'
202: and paa.pre_payment_id = ppp.pre_payment_id
203: and ppp.assignment_action_id = paa1.assignment_action_id