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_NL_SOE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 128: pay_assignment_actions paa,

124: from pay_run_result_values prrv,
125: pay_run_results prr,
126: pay_element_types_f pet,
127: pay_input_values_f piv,
128: pay_assignment_actions paa,
129: pay_payroll_actions ppa
130: where prrv.run_result_id = prr.run_result_id
131: and paa.assignment_action_id=lp_assignment_action_id
132: and prr.assignment_action_id = paa.assignment_action_id

Line 302: from pay_assignment_actions aa

298: || ''''''SI Type Name'''''' || '')'') COL04
299: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
300: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
301: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
302: from pay_assignment_actions aa
303: , pay_run_results rr
304: , pay_run_result_values rrv
305: , pay_input_values_f iv
306: , pay_input_values_f_tl ivtl

Line 409: pay_assignment_actions paa,

405: --
406: /* bug 4253982 */
407: cursor getAsgActions(l_assignment_action_id number,l_eff_date date) is
408: select paa.assignment_action_id from
409: pay_assignment_actions paa,
410: pay_payroll_actions ppa
411: where paa.assignment_id =
412: ( select assignment_id
413: from pay_assignment_actions

Line 413: from pay_assignment_actions

409: pay_assignment_actions paa,
410: pay_payroll_actions ppa
411: where paa.assignment_id =
412: ( select assignment_id
413: from pay_assignment_actions
414: where assignment_action_id = l_assignment_action_id
415: )
416: and paa.action_status IN ('C','S') -- 10228241
417: and paa.assignment_action_id < l_assignment_action_id

Line 431: , pay_assignment_actions aa

427: , pa.business_group_id
428: , bg.legislation_code
429: , lrl.rule_mode
430: from pay_payroll_actions pa
431: , pay_assignment_actions aa
432: , per_business_groups bg
433: , pay_legislation_rules lrl
434: where aa.assignment_action_id = p_assignment_action_id
435: and aa.payroll_action_id = pa.payroll_action_id

Line 506: from pay_assignment_actions aa,

502: , decode(l_st2_needed_chr,
503: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
504: ,rr.run_result_id)
505: ,null) source_text2
506: from pay_assignment_actions aa,
507: pay_payroll_actions pa,
508: pay_run_results rr
509: where aa.ASSIGNMENT_ID = l_assignment_id
510: and aa.assignment_action_id = rr.assignment_action_id