APPS.PAY_CN_REPORT_PKG dependencies on PAY_ACTION_INFORMATION

Line 10: -- balance from PAY_ACTION_INFORMATION --

6: -- Name : GET_BALANCE_VALUE --
7: -- Type : FUNCTION --
8: -- Access : Public --
9: -- Description : Function to return the value of a particular --
10: -- balance from PAY_ACTION_INFORMATION --
11: -- --
12: -- Parameters : --
13: -- IN : p_assignment_action_id NUMBER --
14: -- p_balance_name VARCHAR2 --

Line 42: FROM pay_action_information pai

38: CURSOR csr_bal(c_balance_name VARCHAR2) IS
39: SELECT DECODE(p_dimension_name,
40: 'PTD', action_information5,
41: 'YTD', action_information4) value
42: FROM pay_action_information pai
43: WHERE pai.action_context_id = p_assignment_action_id
44: AND pai.action_context_type = 'AAP'
45: AND pai.action_information_category = 'APAC BALANCES'
46: AND pai.action_information1 = c_balance_name;

Line 57: l_value pay_action_information.action_information4%TYPE;

53: AND pbt.legislation_code = 'CN'
54: AND pbt.balance_type_id = pbtl.balance_type_id
55: AND pbtl.language = userenv('LANG');
56:
57: l_value pay_action_information.action_information4%TYPE;
58: l_procedure_name VARCHAR2(50);
59: l_message VARCHAR2(255);
60: l_balance_name VARCHAR2(255);
61: BEGIN

Line 94: -- element from PAY_ACTION_INFORMATION --

90: -- Name : GET_ELEMENT_VALUE --
91: -- Type : FUNCTION --
92: -- Access : Public --
93: -- Description : Function to return the 'Pay Value' of a particular --
94: -- element from PAY_ACTION_INFORMATION --
95: -- --
96: -- Parameters : --
97: -- IN : p_assignment_action_id NUMBER --
98: -- p_element_name VARCHAR2 --

Line 122: FROM pay_action_information pai

118: IS
119:
120: CURSOR csr_elem(c_element_name VARCHAR2) IS
121: SELECT action_information5 value
122: FROM pay_action_information pai
123: WHERE pai.action_context_id = p_assignment_action_id
124: AND pai.action_context_type = 'AAP'
125: AND pai.action_information_category = 'APAC ELEMENTS'
126: AND pai.action_information1 = c_element_name

Line 138: l_value pay_action_information.action_information4%TYPE;

134: AND pet.legislation_code = 'CN'
135: AND pet.element_type_id = petl.element_type_id
136: AND petl.language = userenv('LANG');
137:
138: l_value pay_action_information.action_information4%TYPE;
139: l_procedure_name VARCHAR2(50);
140: l_message VARCHAR2(255);
141: l_element_name VARCHAR2(255);
142: BEGIN

Line 176: -- particular element from PAY_ACTION_INFORMATION --

172: -- Name : GET_ELEMENT_VALUE --
173: -- Type : FUNCTION --
174: -- Access : Public --
175: -- Description : Function to return the specified input value of a --
176: -- particular element from PAY_ACTION_INFORMATION --
177: -- --
178: -- Parameters : --
179: -- IN : p_assignment_action_id NUMBER --
180: -- p_element_name VARCHAR2 --

Line 204: FROM pay_action_information pai

200: IS
201:
202: CURSOR csr_elem(c_element_name VARCHAR2) IS
203: SELECT action_information5 value
204: FROM pay_action_information pai
205: WHERE pai.action_context_id = p_assignment_action_id
206: AND pai.action_context_type = 'AAP'
207: AND pai.action_information_category = 'APAC ELEMENTS'
208: AND pai.action_information1 = c_element_name

Line 220: l_value pay_action_information.action_information4%TYPE;

216: AND pet.legislation_code = 'CN'
217: AND pet.element_type_id = petl.element_type_id
218: AND petl.language = userenv('LANG');
219:
220: l_value pay_action_information.action_information4%TYPE;
221: l_procedure_name VARCHAR2(50);
222: l_message VARCHAR2(255);
223: l_element_name VARCHAR2(255);
224: BEGIN