eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

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

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

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

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

Line 325: FROM pay_assignment_actions

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

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

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

Line 339: pay_assignment_actions paa

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

Line 438: ,pay_assignment_actions pac

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