APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 204: FROM pay_assignment_actions paa_xfr,

200: AND application_id = 801; /* Bug 6522667 */
201:
202: CURSOR csr_get_chk_no IS
203: SELECT paa_chk.serial_number
204: FROM pay_assignment_actions paa_xfr,
205: pay_action_interlocks pai_xfr,
206: pay_action_interlocks pai_chk,
207: pay_assignment_actions paa_chk,
208: pay_payroll_actions ppa_chk

Line 207: pay_assignment_actions paa_chk,

203: SELECT paa_chk.serial_number
204: FROM pay_assignment_actions paa_xfr,
205: pay_action_interlocks pai_xfr,
206: pay_action_interlocks pai_chk,
207: pay_assignment_actions paa_chk,
208: pay_payroll_actions ppa_chk
209: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id
210: AND pai_xfr.locked_action_id = pai_chk.locked_action_id
211: AND pai_chk.locking_action_id = paa_chk.assignment_action_id

Line 218: l_chk_no pay_assignment_actions.serial_number%type;

214: AND paa_xfr.assignment_action_id = g_action_ctx_id;
215:
216: l_proc_name varchar2(100);
217: l_tag_name varchar2(500);
218: l_chk_no pay_assignment_actions.serial_number%type;
219: l_data pay_action_information.action_information1%type;
220:
221: BEGIN
222: l_proc_name := g_proc_name || 'LOAD_XML';

Line 477: FROM pay_assignment_actions paa,

473: ) AS
474:
475: CURSOR get_leg_code IS
476: SELECT hoi2.org_information9
477: FROM pay_assignment_actions paa,
478: pay_payroll_actions ppa,
479: hr_organization_units hou,
480: hr_organization_information hoi1,
481: hr_organization_information hoi2

Line 507: FROM pay_assignment_actions

503: AND action_context_id = p_action_context_id)
504: OR (action_context_type = 'PA'
505: AND action_context_id =
506: (SELECT payroll_action_id
507: FROM pay_assignment_actions
508: WHERE assignment_action_id = p_action_context_id)))
509: OR (action_information_id = p_action_information_id
510: AND p_action_information_id IS NOT NULL)
511: ORDER BY decode (action_information_category,'EMPLOYEE DETAILS', 1, 2);