APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_ALL_PAYROLLS_F

Line 3754: lv_period_type pay_all_payrolls_f.period_type%TYPE;

3750: RETURN NUMBER IS
3751:
3752: ln_periodic_earnings NUMBER;
3753: ln_days_in_a_month NUMBER;
3754: lv_period_type pay_all_payrolls_f.period_type%TYPE;
3755:
3756: BEGIN
3757:
3758: hr_utility_trace('Entering ..CONVERT_INTO_MONTHLY_SALARY');

Line 3763: FROM pay_all_payrolls_f ppf,

3759: hr_utility_trace('p_periodic_earnings: ' ||p_periodic_earnings);
3760:
3761: SELECT period_type
3762: INTO lv_period_type
3763: FROM pay_all_payrolls_f ppf,
3764: fnd_sessions fs
3765: WHERE payroll_id = p_payroll_id
3766: AND fs.effective_date BETWEEN ppf.effective_start_date
3767: AND ppf.effective_end_date

Line 4255: lv_period_type pay_all_payrolls_f.period_type%TYPE;

4251: RETURN NUMBER IS
4252:
4253: ln_subject_earnings NUMBER;
4254: ln_days_in_a_month NUMBER;
4255: lv_period_type pay_all_payrolls_f.period_type%TYPE;
4256: ln_row_count NUMBER;
4257: lv_end_date varchar2(24);
4258: lv_start_date varchar2(24);
4259: ln_time_period_id number;