APPS.PAY_DK_EINR 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 1000*/

Line 22: FROM pay_action_information pai

18: /* Cursors */
19: /* Cursor to fetch data related to Record 1000*/
20: CURSOR csr_1000 (p_payroll_action_id NUMBER) IS
21: SELECT pai.*
22: FROM pay_action_information pai
23: WHERE pai.action_context_id= p_payroll_action_id
24: AND pai.action_context_type= 'PA'
25: AND pai.action_information_category = 'EMEA REPORT INFORMATION'
26: AND pai.action_information1 = 'PYDKEINA'

Line 33: FROM pay_action_information pai

29:
30: /* Cursor to fetch data related to Record 2001*/
31: CURSOR csr_2001 (p_payroll_action_id NUMBER) IS
32: SELECT pai.*
33: FROM pay_action_information pai
34: WHERE pai.action_context_id= p_payroll_action_id
35: AND pai.action_context_type= 'PA'
36: AND pai.action_information_category = 'EMEA REPORT INFORMATION'
37: AND pai.action_information1 = 'PYDKEINA'

Line 48: FROM pay_action_information pai , pay_assignment_actions paa

44:
45: /* Cursor to fetch data related to Record 2101*/
46: CURSOR csr_2101(p_payroll_action_id NUMBER) IS
47: SELECT pai.*
48: FROM pay_action_information pai , pay_assignment_actions paa
49: WHERE paa.payroll_action_id = p_payroll_action_id
50: AND pai.action_context_id= paa.assignment_action_id
51: AND pai.action_context_type= 'AAP'
52: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 62: FROM pay_action_information pai

58:
59: /* Cursor to fetch data related to Record 5000*/
60: CURSOR csr_5000(p_payroll_action_id NUMBER) IS
61: SELECT pai.*
62: FROM pay_action_information pai
63: WHERE pai.action_context_id = p_payroll_action_id
64: AND pai.action_context_type= 'PA'
65: AND pai.action_information_category = 'EMEA REPORT INFORMATION'
66: AND pai.action_information1 = 'PYDKEINA'

Line 74: FROM pay_action_information pai, pay_assignment_actions paa

70:
71: /* Cursor to fetch data related to Record 6000*/
72: CURSOR csr_6000(p_payroll_action_id NUMBER) IS
73: SELECT pai.*
74: FROM pay_action_information pai, pay_assignment_actions paa
75: WHERE paa.payroll_action_id= p_payroll_action_id
76: AND pai.action_context_id= paa.assignment_action_id
77: AND pai.action_context_type= 'AAP'
78: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 88: FROM pay_action_information pai, pay_assignment_actions paa

84:
85: /* Cursor to fetch data related to Record 6001 */
86: CURSOR csr_6001(p_payroll_action_id NUMBER, p_assignment_id NUMBER) IS
87: SELECT pai.*
88: FROM pay_action_information pai, pay_assignment_actions paa
89: WHERE paa.payroll_action_id= p_payroll_action_id
90: AND pai.action_context_id= paa.assignment_action_id
91: AND pai.action_context_type= 'AAP'
92: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 103: FROM pay_action_information pai, pay_assignment_actions paa

99:
100: /* Cursor to fetch data related to Record 6002 */
101: CURSOR csr_6002(p_payroll_action_id NUMBER, p_assignment_id NUMBER) IS
102: SELECT pai.*
103: FROM pay_action_information pai, pay_assignment_actions paa
104: WHERE paa.payroll_action_id= p_payroll_action_id
105: AND pai.action_context_id= paa.assignment_action_id
106: AND pai.action_context_type= 'AAP'
107: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 117: FROM pay_action_information pai, pay_assignment_actions paa

113:
114: /* Cursor to fetch data related to Record 6004 */
115: CURSOR csr_6004(p_payroll_action_id NUMBER, p_assignment_id NUMBER) IS
116: SELECT pai.*
117: FROM pay_action_information pai, pay_assignment_actions paa
118: WHERE paa.payroll_action_id= p_payroll_action_id
119: AND pai.action_context_id= paa.assignment_action_id
120: AND pai.action_context_type= 'AAP'
121: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 131: FROM pay_action_information pai, pay_assignment_actions paa

127:
128: /* Cursor to fetch data related to Record 6005 */
129: CURSOR csr_6005(p_payroll_action_id NUMBER, p_assignment_id NUMBER) IS
130: SELECT pai.*
131: FROM pay_action_information pai, pay_assignment_actions paa
132: WHERE paa.payroll_action_id= p_payroll_action_id
133: AND pai.action_context_id= paa.assignment_action_id
134: AND pai.action_context_type= 'AAP'
135: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 145: FROM pay_action_information pai

141:
142: /* Cursor to fetch data related to Record 9999 */
143: CURSOR csr_9999(p_payroll_action_id NUMBER) IS
144: SELECT pai.*
145: FROM pay_action_information pai
146: WHERE pai.action_context_id = p_payroll_action_id
147: AND pai.action_context_type= 'PA'
148: AND pai.action_information_category = 'EMEA REPORT INFORMATION'
149: AND pai.action_information1 = 'PYDKEINA'