APPS.PAY_FI_PAYLIST dependencies on PAY_PAYROLL_ACTIONS

Line 14: FROM pay_payroll_actions ppa,

10: THEN
11: BEGIN
12: SELECT payroll_action_id
13: INTO l_payroll_action_id
14: FROM pay_payroll_actions ppa,
15: fnd_conc_req_summary_v fcrs,
16: fnd_conc_req_summary_v fcrs1
17: WHERE fcrs.request_id = fnd_global.conc_request_id
18: AND fcrs.priority_request_id = fcrs1.priority_request_id

Line 58: pay_payroll_actions ppa

54: pai.action_information6 pay_day,
55: pai.action_information7
56: end_date
57: FROM pay_action_information pai,
58: pay_payroll_actions ppa
59: WHERE pai.action_context_id = ppa.payroll_action_id
60: AND ppa.payroll_action_id = csr_v_pa_id;
61: CSR_HEADER_REC CSR_HEADER%ROWTYPE;
62:

Line 85: FROM pay_payroll_actions ppa,

81: after_tax_deductions,
82: pai_ass.action_information12 net_pay,
83: pai_ass.action_information13 capital_income_base,
84: pai_ass.action_information14 assignment_number
85: FROM pay_payroll_actions ppa,
86: pay_assignment_actions paa,
87: pay_action_information pai_ass
88: WHERE ppa.payroll_action_id = csr_v_pa_id
89: AND paa.payroll_action_id = ppa.payroll_action_id

Line 113: FROM pay_payroll_actions ppa,

109: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information11))
110: after_tax_deductions,
111: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information12))net_pay,
112: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information13)) capital_income_base
113: FROM pay_payroll_actions ppa,
114: pay_assignment_actions paa,
115: pay_action_information pai_ass
116: WHERE ppa.payroll_action_id = csr_v_pa_id
117: AND paa.payroll_action_id = ppa.payroll_action_id