APPS.PAY_NL_TAXOFFICE_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 27: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

23: ,p_token in varchar2
24: ,p_segment_number in number default null ) RETURN varchar2
25: IS
26:
27: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
28: l_start_pos NUMBER;
29: l_delimiter varchar2(1):=' ';
30: l_proc VARCHAR2(400):= g_package||' get parameter ';
31:

Line 93: FROM pay_payroll_actions

89: ,pay_nl_taxoffice_archive.get_parameter(legislative_parameters,'EMPLOYER_ID')
90: -- ,pay_nl_taxoffice_archive.get_parameter(legislative_parameters,'ORG_HIERARCHY')
91: ,effective_date
92: ,business_group_id
93: FROM pay_payroll_actions
94: WHERE payroll_action_id = p_payroll_action_id;
95: --
96: l_effective_date date;
97: l_proc VARCHAR2(400):= g_package||' get_all_parameters ';

Line 177: ,pay_payroll_actions ppa

173: eligible for archival */
174:
175: sqlstr := 'SELECT DISTINCT person_id
176: FROM per_people_f ppf
177: ,pay_payroll_actions ppa
178: WHERE ppa.payroll_action_id = :payroll_action_id
179: AND ppa.business_group_id = ppf.business_group_id
180: ORDER BY ppf.person_id';
181:

Line 742: ,pay_payroll_actions ppa

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
746: and ppa.action_type in ('R','B','Q','I','V');

Line 2012: ,pay_payroll_actions ppa

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
2016: ppa.date_earned between p_tax_year_start_date and p_tax_year_end_date

Line 2090: from pay_payroll_actions ppa,

2086: BEGIN
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:

Line 2431: pay_payroll_actions ppa,

2427:
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,

Line 2458: pay_payroll_actions ppa,

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,
2462: pay_run_result_values prrv,

Line 2637: pay_payroll_actions ppa,

2633:
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,

Line 2663: pay_payroll_actions ppa,

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,
2667: pay_run_result_values prrv

Line 2727: (select /*+ USE_NL(paa, ppa, pet,prr) */ prr.run_result_id,ppa.date_earned from pay_payroll_actions ppa

2723: CURSOR csr_si_insured_flag(lp_element_name varchar2) is
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