APPS.PAY_DK_EINR dependencies on PAY_ASSIGNMENT_ACTIONS

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 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'