APPS.PAY_MX_SOE_SS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 139: from pay_payroll_actions

135: where assignment_action_id = cp_assignment_action_id;
136:
137: CURSOR c_action_type(cp_payroll_action_id NUMBER) IS
138: select action_type
139: from pay_payroll_actions
140: where payroll_action_id = cp_payroll_action_id;
141:
142: ln_tax_unit_id number;
143: ln_pyrl_act_id number;

Line 380: from pay_payroll_actions pa

376: , aa.tax_unit_id
377: ,'''' || bg.currency_code || '''' currency_code
378: ,action_type
379: ,fc.name currency_name
380: from pay_payroll_actions pa
381: , pay_assignment_actions aa
382: , per_business_groups bg
383: , fnd_currencies_vl fc
384: where aa.assignment_action_id = p_assignment_action_id

Line 401: l_action_type pay_payroll_actions.action_type%type;

397: start with assignment_action_id = p_assignment_action_id)
398: connect by source_action_id = prior assignment_action_id
399: start with assignment_action_id = p_assignment_action_id;
400:
401: l_action_type pay_payroll_actions.action_type%type;
402:
403: cursor lockedActions is
404: select locked_action_id,
405: action_sequence

Line 433: from pay_payroll_actions pa

429: --
430: -- Prepay change
431: select action_type
432: into l_action_type
433: from pay_payroll_actions pa
434: ,pay_assignment_actions aa
435: where aa.assignment_action_id = p_assignment_action_id
436: and aa.payroll_action_id = pa.payroll_action_id;
437: