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 749: ,pay_payroll_actions ppa

745: SELECT
746: --MAX(assignment_action_id) --11868538
747: fnd_number.canonical_to_number(substr(max(lpad(NVL(paa.action_sequence,0),15,'0')||paa.assignment_action_id),16)) Max_Asg_Act
748: from pay_assignment_actions paa
749: ,pay_payroll_actions ppa
750: ,pay_payrolls_f ppf
751: where paa.payroll_action_id =ppa.payroll_action_id
752: and paa.assignment_id = p_assignment_id
753: --11854614

Line 2025: ,pay_payroll_actions ppa

2021:
2022: cursor csr_tax_year_assgn_act_id is
2023: select paa.assignment_action_id,ppa.date_earned
2024: from pay_assignment_actions paa
2025: ,pay_payroll_actions ppa
2026: ,pay_payrolls_f ppf
2027: where
2028: paa.assignment_id = p_assignment_id and
2029: ppa.payroll_action_id = paa.payroll_action_id and

Line 2108: from pay_payroll_actions ppa,

2104: BEGIN
2105:
2106: select ppa.date_earned
2107: into l_eff_date
2108: from pay_payroll_actions ppa,
2109: pay_assignment_actions paa
2110: where paa.assignment_action_id = p_assgt_act_id
2111: and ppa.payroll_action_id = paa.payroll_action_id;
2112:

Line 2449: pay_payroll_actions ppa,

2445:
2446: CURSOR csr_wtd_code is
2447: /* select decode(prrv.result_value,'NL_NONE','0','1') code,ppa.date_earned,paa.assignment_action_id,ptp.start_date --,prrv.result_value
2448: from
2449: pay_payroll_actions ppa,
2450: pay_assignment_actions paa,
2451: pay_element_types_f pet,
2452: pay_input_values_f piv,
2453: pay_run_results prr,

Line 2477: pay_payroll_actions ppa,

2473: 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
2474: from
2475: pay_payrolls_f ppf,
2476: pay_assignment_actions paa,
2477: pay_payroll_actions ppa,
2478: pay_element_types_f pet,
2479: pay_input_values_f piv,
2480: pay_run_results prr,
2481: pay_run_result_values prrv,

Line 2660: pay_payroll_actions ppa,

2656:
2657: CURSOR csr_wage_tax_table_code is
2658: /* select count(prrv.result_value) counter,prrv.result_value
2659: from
2660: pay_payroll_actions ppa,
2661: pay_assignment_actions paa,
2662: pay_element_types_f pet,
2663: pay_input_values_f piv,
2664: pay_run_results prr,

Line 2687: pay_payroll_actions ppa,

2683: select /*+ ORDERED */ count(prrv.result_value) counter,prrv.result_value
2684: from
2685: pay_payrolls_f ppf,
2686: pay_assignment_actions paa,
2687: pay_payroll_actions ppa,
2688: pay_element_types_f pet,
2689: pay_input_values_f piv,
2690: pay_run_results prr,
2691: pay_run_result_values prrv

Line 2757: ,pay_payroll_actions ppa

2753: select 1 from dual
2754: where exists
2755: (select /*+ USE_NL(paa, ppa, pet,prr) */ prr.run_result_id,ppa.date_earned from
2756: pay_payrolls_f ppf
2757: ,pay_payroll_actions ppa
2758: ,pay_assignment_actions paa
2759: ,pay_run_results prr
2760: ,pay_element_types_f pet
2761: where ppa.payroll_action_id = paa.payroll_action_id