APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on PAY_ACTION_INFORMATION

Line 23: in pay_action_information. Calling applications can invoke

19:
20: Name : pay_payroll_xml_extract_pkg
21:
22: Description : This package handles generation of XML from data archived
23: in pay_action_information. Calling applications can invoke
24: one of the overloaded versions of GENERATE procedure with
25: appropriate parameters to obtain the XML. This package has
26: other public procedures which GENERATE uses for processing.
27: They might not be of much use if invoked directly by calling

Line 78: TYPE char_tab_type IS TABLE OF pay_action_information.action_information1%type

74: on Simulation Code.
75: *****************************************************************************/
76:
77: TYPE int_tab_type IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;
78: TYPE char_tab_type IS TABLE OF pay_action_information.action_information1%type
79: INDEX BY BINARY_INTEGER;
80: TYPE param_rec IS RECORD (
81: parameter_name varchar2(50),
82: parameter_value varchar2(500)

Line 155: P_XML pay_action_information.action_information1%type

151: LOAD_XML_DATA should be used if such validations are required
152: to be performed implicitly.
153: *****************************************************************************/
154: PROCEDURE LOAD_XML (
155: P_XML pay_action_information.action_information1%type
156: );
157:
158:
159: /****************************************************************************

Line 274: FROM pay_action_information

270: action_information27,
271: action_information28,
272: action_information29,
273: action_information30
274: FROM pay_action_information
275: WHERE (action_information_id = p_action_information_id AND p_action_information_id IS NOT NULL)
276: AND action_information_category = p_category
277: UNION ALL /* Bug 6522667, added UNION ALL */
278: SELECT nvl((select overriding_dd_date from pay_payroll_actions where payroll_action_id=(select pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') from dual)),effective_date) effective_date,

Line 309: FROM pay_action_information

305: action_information27,
306: action_information28,
307: action_information29,
308: action_information30
309: FROM pay_action_information
310: WHERE ((action_context_id = p_action_context_id AND action_context_type = 'AAP') OR
311: (action_context_id = (SELECT payroll_action_id
312: FROM pay_assignment_actions
313: WHERE assignment_action_id = p_action_context_id)

Line 366: FROM pay_action_information

362: action_information27,
363: action_information28,
364: action_information29,
365: action_information30
366: FROM pay_action_information
367: WHERE action_information_category = p_category
368: AND (action_information_category like '%THIRD PARTY CHECKS' or action_information_category like '%THIRD PARTY CHEQUES')
369: AND action_context_id = p_action_context_id
370: AND action_information2 = p_pre_payment_id;