APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_ALL_PAYROLLS_F

Line 2456: lv_period_type pay_all_payrolls_f.period_type%TYPE;

2452: RETURN NUMBER IS
2453:
2454: ln_periodic_earnings NUMBER;
2455: ln_days_in_a_month NUMBER;
2456: lv_period_type pay_all_payrolls_f.period_type%TYPE;
2457:
2458: BEGIN
2459:
2460: hr_utility_trace('Entering ..CONVERT_INTO_MONTHLY_SALARY');

Line 2465: FROM pay_all_payrolls_f ppf,

2461: hr_utility_trace('p_periodic_earnings: ' ||p_periodic_earnings);
2462:
2463: SELECT period_type
2464: INTO lv_period_type
2465: FROM pay_all_payrolls_f ppf,
2466: fnd_sessions fs
2467: WHERE payroll_id = p_payroll_id
2468: AND fs.effective_date BETWEEN ppf.effective_start_date
2469: AND ppf.effective_end_date

Line 2957: lv_period_type pay_all_payrolls_f.period_type%TYPE;

2953: RETURN NUMBER IS
2954:
2955: ln_subject_earnings NUMBER;
2956: ln_days_in_a_month NUMBER;
2957: lv_period_type pay_all_payrolls_f.period_type%TYPE;
2958: ln_row_count NUMBER;
2959: lv_end_date varchar2(24);
2960: lv_start_date varchar2(24);
2961: ln_time_period_id number;