APPS.BEN_DISTRIBUTE_RATES dependencies on PAY_ALL_PAYROLLS_F

Line 420: from pay_all_payrolls_f

416: --
417: cursor get_period_type(p_payroll_id IN NUMBER
418: ,p_date IN DATE) is
419: select period_type
420: from pay_all_payrolls_f
421: where payroll_id = p_payroll_id
422: and p_date between effective_start_date
423: and effective_end_date;
424:

Line 1060: from pay_all_payrolls_f

1056: cursor get_period_type(p_payroll_id IN NUMBER
1057: ,p_date IN DATE) is
1058: select period_type
1059: ,pay_date_offset
1060: from pay_all_payrolls_f
1061: where payroll_id = p_payroll_id
1062: and p_date between effective_start_date
1063: and effective_end_date;
1064:

Line 3183: from pay_all_payrolls_f prl

3179: --
3180: cursor c_payroll (p_payroll_id number,
3181: p_effective_date date) is
3182: select pay_date_offset
3183: from pay_all_payrolls_f prl
3184: where prl.payroll_id = p_payroll_id
3185: and p_effective_date between prl.effective_start_date
3186: and prl.effective_end_date;
3187: --

Line 3543: from pay_all_payrolls_f prl

3539: --
3540: cursor c_payroll (p_payroll_id number,
3541: p_effective_date date) is
3542: select pay_date_offset
3543: from pay_all_payrolls_f prl
3544: where prl.payroll_id = p_payroll_id
3545: and p_effective_date between prl.effective_start_date
3546: and prl.effective_end_date;
3547: --

Line 3888: from pay_all_payrolls_f prl

3884: abr.effective_start_date and abr.effective_end_date;
3885: --
3886: cursor c_payroll is
3887: select pay_date_offset
3888: from pay_all_payrolls_f prl
3889: where prl.payroll_id = p_payroll_id
3890: and p_effective_date between prl.effective_start_date
3891: and prl.effective_end_date;
3892: --