APPS.PAY_FI_DPSR dependencies on PAY_ACTION_INFORMATION

Line 15: l_payroll_action_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE;

11:
12: /* Start of declaration*/
13: -- Variables needed for the report
14: l_counter number := 0;
15: l_payroll_action_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE;
16: /* End of declaration*/
17:
18: /* Cursors */
19: /* Cursor to fetch data related to Record 1 of VSPSERIE*/

Line 22: FROM pay_action_information pai , pay_assignment_actions paa

18: /* Cursors */
19: /* Cursor to fetch data related to Record 1 of VSPSERIE*/
20: CURSOR csr_VSPSERIE1 (p_payroll_action_id NUMBER) IS
21: SELECT pai.*
22: FROM pay_action_information pai , pay_assignment_actions paa
23: WHERE paa.payroll_action_id = p_payroll_action_id
24: AND pai.action_context_id= paa.assignment_action_id
25: AND pai.action_context_type= 'AAP'
26: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 35: FROM pay_action_information pai , pay_assignment_actions paa

31:
32: /* Cursor to fetch data related to Record 2 of VSPSERIE*/
33: CURSOR csr_VSPSERIE2 (p_payroll_action_id NUMBER, p_action_context_id NUMBER) IS
34: SELECT pai.*
35: FROM pay_action_information pai , pay_assignment_actions paa
36: WHERE paa.payroll_action_id = p_payroll_action_id
37: AND pai.action_context_id= paa.assignment_action_id
38: AND pai.action_context_type= 'AAP'
39: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 52: FROM pay_action_information pai , pay_assignment_actions paa

48:
49: /* Cursor to fetch data related to Record VSRAERIE*/
50: CURSOR csr_VSRAERIE(p_payroll_action_id NUMBER) IS
51: SELECT pai.*
52: FROM pay_action_information pai , pay_assignment_actions paa
53: WHERE paa.payroll_action_id = p_payroll_action_id
54: AND pai.action_context_id= paa.assignment_action_id
55: AND pai.action_context_type= 'AAP'
56: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 64: FROM pay_action_information pai , pay_assignment_actions paa

60:
61: /* Cursor to fetch data related to Record VSPSTUKI*/
62: CURSOR csr_VSPSTUKI(p_payroll_action_id NUMBER) IS
63: SELECT pai.*
64: FROM pay_action_information pai , pay_assignment_actions paa
65: WHERE paa.payroll_action_id = p_payroll_action_id
66: AND pai.action_context_id= paa.assignment_action_id
67: AND pai.action_context_type= 'AAP'
68: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 76: FROM pay_action_information pai

72:
73: /* Cursor to fetch data related to Record VSPSVYSL*/
74: CURSOR csr_VSPSVYSL(p_payroll_action_id NUMBER) IS
75: SELECT *
76: FROM pay_action_information pai
77: WHERE pai.action_context_id= p_payroll_action_id
78: AND pai.action_context_type= 'PA'
79: AND pai.action_information_category = 'EMEA REPORT INFORMATION'
80: AND pai.action_information1 = 'PYFIDPSA'

Line 88: FROM pay_action_information pai

84:
85: /* Cursor to fetch data related to Record VSPSVYHT*/
86: CURSOR csr_VSPSVYHT(p_payroll_action_id NUMBER) IS
87: SELECT *
88: FROM pay_action_information pai
89: WHERE pai.action_context_id= p_payroll_action_id
90: AND pai.action_context_type= 'PA'
91: AND pai.action_information_category = 'EMEA REPORT INFORMATION'
92: AND pai.action_information1 = 'PYFIDPSA'