APPS.PAY_FI_ACRR dependencies on PAY_ACTION_INFORMATION

Line 42: l_payroll_action_id pay_action_information.action_information1%TYPE;

38: /* Start of declaration*/
39: -- Variables needed for the report
40: l_sum NUMBER;
41: l_counter NUMBER := 1;
42: l_payroll_action_id pay_action_information.action_information1%TYPE;
43: CURSOR csr_Element_data (csr_v_pa_id IN VARCHAR2)
44: IS
45: SELECT pai.action_information2 Legal_Employer,
46: pai.action_information10 Start_Date,

Line 54: FROM pay_action_information pai,

50: pai4.action_information4 Element_name,
51: pai4.action_information6 Account_number,
52: nvl(pai4.action_information7,0) Credit,
53: nvl(pai4.action_information8,0) Debit
54: FROM pay_action_information pai,
55: pay_payroll_actions ppa,
56: pay_action_information pai1,
57: pay_action_information pai2,
58: pay_action_information pai4

Line 56: pay_action_information pai1,

52: nvl(pai4.action_information7,0) Credit,
53: nvl(pai4.action_information8,0) Debit
54: FROM pay_action_information pai,
55: pay_payroll_actions ppa,
56: pay_action_information pai1,
57: pay_action_information pai2,
58: pay_action_information pai4
59: WHERE pai.action_context_id = ppa.payroll_action_id
60: AND ppa.payroll_action_id = csr_v_pa_id

Line 57: pay_action_information pai2,

53: nvl(pai4.action_information8,0) Debit
54: FROM pay_action_information pai,
55: pay_payroll_actions ppa,
56: pay_action_information pai1,
57: pay_action_information pai2,
58: pay_action_information pai4
59: WHERE pai.action_context_id = ppa.payroll_action_id
60: AND ppa.payroll_action_id = csr_v_pa_id
61: AND pai.action_context_id = pai1.action_context_id

Line 58: pay_action_information pai4

54: FROM pay_action_information pai,
55: pay_payroll_actions ppa,
56: pay_action_information pai1,
57: pay_action_information pai2,
58: pay_action_information pai4
59: WHERE pai.action_context_id = ppa.payroll_action_id
60: AND ppa.payroll_action_id = csr_v_pa_id
61: AND pai.action_context_id = pai1.action_context_id
62: AND pai1.action_context_id= pai2.action_context_id