APPS.BEN_DISTRIBUTE_RATES dependencies on PAY_ALL_PAYROLLS_F

Line 454: from pay_all_payrolls_f

450: --
451: cursor get_period_type(p_payroll_id IN NUMBER
452: ,p_date IN DATE) is
453: select period_type
454: from pay_all_payrolls_f
455: where payroll_id = p_payroll_id
456: and p_date between effective_start_date
457: and effective_end_date;
458:

Line 1100: from pay_all_payrolls_f

1096: cursor get_period_type(p_payroll_id IN NUMBER
1097: ,p_date IN DATE) is
1098: select period_type
1099: ,pay_date_offset
1100: from pay_all_payrolls_f
1101: where payroll_id = p_payroll_id
1102: and p_date between effective_start_date
1103: and effective_end_date;
1104:

Line 2727: from pay_all_payrolls_f

2723: --
2724: cursor get_period_type(p_payroll_id IN NUMBER
2725: ,p_date IN DATE) is
2726: select period_type
2727: from pay_all_payrolls_f
2728: where payroll_id = p_payroll_id
2729: and p_date between effective_start_date
2730: and effective_end_date;
2731:

Line 3060: from pay_all_payrolls_f

3056: -- 12976212
3057: cursor get_period_type(p_payroll_id IN NUMBER
3058: ,p_date IN DATE) is
3059: select period_type
3060: from pay_all_payrolls_f
3061: where payroll_id = p_payroll_id
3062: and p_date between effective_start_date
3063: and effective_end_date;
3064: -- end 12976212

Line 3400: from pay_all_payrolls_f prl

3396: --
3397: cursor c_payroll (p_payroll_id number,
3398: p_effective_date date) is
3399: select pay_date_offset
3400: from pay_all_payrolls_f prl
3401: where prl.payroll_id = p_payroll_id
3402: and p_effective_date between prl.effective_start_date
3403: and prl.effective_end_date;
3404: --

Line 3810: from pay_all_payrolls_f prl

3806: --
3807: cursor c_payroll (p_payroll_id number,
3808: p_effective_date date) is
3809: select pay_date_offset
3810: from pay_all_payrolls_f prl
3811: where prl.payroll_id = p_payroll_id
3812: and p_effective_date between prl.effective_start_date
3813: and prl.effective_end_date;
3814: --

Line 4207: from pay_all_payrolls_f prl

4203: abr.effective_start_date and abr.effective_end_date;
4204: --
4205: cursor c_payroll is
4206: select pay_date_offset
4207: from pay_all_payrolls_f prl
4208: where prl.payroll_id = p_payroll_id
4209: and p_effective_date between prl.effective_start_date
4210: and prl.effective_end_date;
4211: --