APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_PAYROLLS_F

Line 879: FROM pay_payrolls_f ppf,

875: SELECT TRUNC(ptp.end_date - ptp.start_date) + 1 days,
876: ppf.payroll_id,
877: paa.tax_unit_id,
878: paa.assignment_id
879: FROM pay_payrolls_f ppf,
880: per_time_periods ptp,
881: pay_assignment_actions paa,
882: pay_payroll_actions ppa
883: WHERE ptp.payroll_id = ppf.payroll_id

Line 926: l_payroll_id pay_payrolls_f.payroll_id%TYPE;

922: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
923: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
924: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
925: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
926: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
927: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
928: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
929: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;
930: ln_person_id per_all_people_f.person_id%TYPE;

Line 2195: from pay_payrolls_f

2191:
2192: if ln_payroll_id is not null then
2193: select min(period_type)
2194: into lv_period_type
2195: from pay_payrolls_f
2196: where payroll_id = ln_payroll_id;
2197: end if;
2198:
2199: OPEN csr_get_first_pay_date;