DBA Data[Home] [Help]

APPS.PAY_SE_TAX_DECL_REPORT 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 176: pay_payroll_actions ppa,

172: fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below, -- EOY 2008
173: fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below -- EOY 2008
174: FROM
175: pay_action_information pai,
176: pay_payroll_actions ppa,
177: pay_action_information pai1,
178: pay_action_information pai2
179: WHERE
180: pai.action_context_id = ppa.payroll_action_id

Line 1838: pay_payroll_actions ppa,

1834: fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below, -- EOY 2008
1835: fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below -- EOY 2008
1836: FROM
1837: pay_action_information pai,
1838: pay_payroll_actions ppa,
1839: pay_action_information pai1,
1840: pay_action_information pai2
1841: WHERE
1842: pai.action_context_id = ppa.payroll_action_id