APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_PAYROLLS_F

Line 948: FROM pay_payrolls_f ppf,

944: SELECT TRUNC(ptp.end_date - ptp.start_date) + 1 days,
945: ppf.payroll_id,
946: paa.tax_unit_id,
947: paa.assignment_id
948: FROM pay_payrolls_f ppf,
949: per_time_periods ptp,
950: pay_assignment_actions paa,
951: pay_payroll_actions ppa
952: WHERE ptp.payroll_id = ppf.payroll_id

Line 1017: l_payroll_id pay_payrolls_f.payroll_id%TYPE;

1013: l_low_range_basis pay_mx_earn_exemption_rules_f.low_range_basis%TYPE;
1014: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
1015: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
1016: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
1017: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
1018: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1019: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1020: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;
1021: ln_person_id per_all_people_f.person_id%TYPE;

Line 2389: from pay_payrolls_f

2385:
2386: if ln_payroll_id is not null then
2387: select min(period_type)
2388: into lv_period_type
2389: from pay_payrolls_f
2390: where payroll_id = ln_payroll_id;
2391: end if;
2392:
2393: OPEN csr_get_first_pay_date;

Line 3212: from pay_payrolls_f

3208:
3209: if ln_payroll_id is not null then
3210: select min(period_type)
3211: into lv_period_type
3212: from pay_payrolls_f
3213: where payroll_id = ln_payroll_id;
3214: end if;
3215:
3216: OPEN csr_get_first_pay_date;