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

Line 552: SELECT pay_assignment_actions_s.NEXTVAL

548: if g_error_count=0 then
549:
550: /* Creating the archive assignment action */
551:
552: SELECT pay_assignment_actions_s.NEXTVAL
553: INTO l_asg_act_id
554: FROM dual;
555: --
556: -- Create the archive assignment action

Line 741: from pay_assignment_actions paa

737: ,p_date_to date)RETURN number IS
738:
739: CURSOR csr_max_assgt_act_id IS
740: SELECT MAX(assignment_action_id)
741: from pay_assignment_actions paa
742: ,pay_payroll_actions ppa
743: where paa.payroll_action_id =ppa.payroll_action_id
744: and paa.assignment_id = p_assignment_id
745: and ppa.date_earned between p_date_from and p_date_to

Line 2011: from pay_assignment_actions paa

2007: ,p_Amount_Special_indicator out nocopy varchar2) IS
2008:
2009: cursor csr_tax_year_assgn_act_id is
2010: select paa.assignment_action_id,ppa.date_earned
2011: from pay_assignment_actions paa
2012: ,pay_payroll_actions ppa
2013: where
2014: paa.assignment_id = p_assignment_id and
2015: ppa.payroll_action_id = paa.payroll_action_id and

Line 2091: pay_assignment_actions paa

2087:
2088: select ppa.date_earned
2089: into l_eff_date
2090: from pay_payroll_actions ppa,
2091: pay_assignment_actions paa
2092: where paa.assignment_action_id = p_assgt_act_id
2093: and ppa.payroll_action_id = paa.payroll_action_id;
2094:
2095: EXCEPTION

Line 2432: pay_assignment_actions paa,

2428: CURSOR csr_wtd_code is
2429: /* select decode(prrv.result_value,'NL_NONE','0','1') code,ppa.date_earned,paa.assignment_action_id,ptp.start_date --,prrv.result_value
2430: from
2431: pay_payroll_actions ppa,
2432: pay_assignment_actions paa,
2433: pay_element_types_f pet,
2434: pay_input_values_f piv,
2435: pay_run_results prr,
2436: pay_run_result_values prrv,

Line 2457: pay_assignment_actions paa,

2453: /* 14934380*/
2454:
2455: select /*+ORDERED INDEX(ptp PER_TIME_PERIODS_PK) */ decode(prrv.result_value,'NL_NONE','0','1') code,ppa.date_earned,paa.assignment_action_id,ptp.start_date --,prrv.result_value
2456: from
2457: pay_assignment_actions paa,
2458: pay_payroll_actions ppa,
2459: pay_element_types_f pet,
2460: pay_input_values_f piv,
2461: pay_run_results prr,

Line 2638: pay_assignment_actions paa,

2634: CURSOR csr_wage_tax_table_code is
2635: /* select count(prrv.result_value) counter,prrv.result_value
2636: from
2637: pay_payroll_actions ppa,
2638: pay_assignment_actions paa,
2639: pay_element_types_f pet,
2640: pay_input_values_f piv,
2641: pay_run_results prr,
2642: pay_run_result_values prrv

Line 2662: pay_assignment_actions paa,

2658:
2659: /* 14934399*/
2660: select /*+ ORDERED */ count(prrv.result_value) counter,prrv.result_value
2661: from
2662: pay_assignment_actions paa,
2663: pay_payroll_actions ppa,
2664: pay_element_types_f pet,
2665: pay_input_values_f piv,
2666: pay_run_results prr,

Line 2728: ,pay_assignment_actions paa

2724: /* 14934414 */
2725: select 1 from dual
2726: where exists
2727: (select /*+ USE_NL(paa, ppa, pet,prr) */ prr.run_result_id,ppa.date_earned from pay_payroll_actions ppa
2728: ,pay_assignment_actions paa
2729: ,pay_run_results prr
2730: ,pay_element_types_f pet
2731: where ppa.payroll_action_id = paa.payroll_action_id
2732: and paa.assignment_id = p_assignment_id