APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 319: l_tax_unit_id pay_assignment_actions.tax_unit_id%type; /* Bug No : 2518997 */

315:
316: l_action_info_id NUMBER;
317: l_balance_value NUMBER;
318: l_ovn NUMBER;
319: l_tax_unit_id pay_assignment_actions.tax_unit_id%type; /* Bug No : 2518997 */
320: l_source pay_run_result_values.result_value%type;
321:
322: /* Start of Bug No : 2518997 */
323:

Line 324: CURSOR csr_tax_unit_id(p_run_assignment_action_id pay_assignment_actions.tax_unit_id%type)

320: l_source pay_run_result_values.result_value%type;
321:
322: /* Start of Bug No : 2518997 */
323:
324: CURSOR csr_tax_unit_id(p_run_assignment_action_id pay_assignment_actions.tax_unit_id%type)
325: IS
326: SELECT tax_unit_id
327: FROM pay_assignment_actions
328: WHERE assignment_action_id = p_run_assignment_action_id;

Line 327: FROM pay_assignment_actions

323:
324: CURSOR csr_tax_unit_id(p_run_assignment_action_id pay_assignment_actions.tax_unit_id%type)
325: IS
326: SELECT tax_unit_id
327: FROM pay_assignment_actions
328: WHERE assignment_action_id = p_run_assignment_action_id;
329:
330: /* End of Bug No : 2518997 */
331:

Line 334: CURSOR csr_set_source_id(p_run_assignment_action_id pay_assignment_actions.tax_unit_id%type)

330: /* End of Bug No : 2518997 */
331:
332: /*Set context for source id*/
333:
334: CURSOR csr_set_source_id(p_run_assignment_action_id pay_assignment_actions.tax_unit_id%type)
335: IS
336: select distinct CONTEXT.result_value
337: from pay_run_result_values CONTEXT
338: ,pay_input_values_f PIVF

Line 341: pay_assignment_actions paa

337: from pay_run_result_values CONTEXT
338: ,pay_input_values_f PIVF
339: ,pay_run_results RR
340: ,pay_payroll_actions PACT,
341: pay_assignment_actions paa
342: where CONTEXT.run_result_id = RR.run_result_id
343: and CONTEXT.input_value_id = PIVF.input_value_id
344: and PIVF.name = 'Source'
345: and paa.assignment_action_id= p_run_assignment_action_id

Line 440: ,pay_assignment_actions pac

436: IS
437: SELECT pac.assignment_action_id
438: ,pac.source_action_id
439: FROM pay_action_interlocks pai
440: ,pay_assignment_actions pac
441: ,pay_payroll_Actions ppa
442: WHERE pai.locking_action_id = p_pre_assignment_action_id
443: AND pai.locked_action_id = pac.assignment_action_id
444: AND ppa.payroll_action_id = pac.payroll_action_id

Line 778: pay_assignment_actions paa

774: ,ppa.date_earned date_earned
775: ,ppa.pay_advice_message payroll_message
776: FROM pay_payrolls_f pp,
777: pay_payroll_actions ppa,
778: pay_assignment_actions paa
779: WHERE ppa.payroll_id = p_payroll_id
780: AND ppa.effective_date BETWEEN p_start_date AND p_end_date
781: AND ppa.action_type = 'Q'
782: AND ppa.action_status = 'C'