APPS.PAY_NL_TAXOFFICE_ARCHIVE dependencies on PAY_PAYROLLS_F

Line 750: ,pay_payrolls_f ppf

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
754: --and ppa.date_earned between p_date_from and p_date_to

Line 2026: ,pay_payrolls_f ppf

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
2030: --11854614

Line 2475: pay_payrolls_f ppf,

2471: /* 14934380*/
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,

Line 2685: pay_payrolls_f ppf,

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

Line 2756: pay_payrolls_f ppf

2752: /* 14934414 */
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