APPS.PAY_NL_TAXOFFICE_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 553: SELECT pay_assignment_actions_s.NEXTVAL

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

Line 748: from pay_assignment_actions paa

744: CURSOR csr_max_assgt_act_id IS
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

Line 2024: from pay_assignment_actions paa

2020: ,p_Amount_Special_indicator out nocopy varchar2) IS
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

Line 2109: pay_assignment_actions paa

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:
2113: EXCEPTION

Line 2450: pay_assignment_actions paa,

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

Line 2476: pay_assignment_actions paa,

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

Line 2661: pay_assignment_actions paa,

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

Line 2686: pay_assignment_actions paa,

2682: /* 14934399*/
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,

Line 2758: ,pay_assignment_actions paa

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
2762: and paa.assignment_id = p_assignment_id