APPS.BEN_ELEMENT_ENTRY dependencies on PAY_PAYROLLS_F

Line 1473: from pay_payrolls_f

1469: ,c_effective_date in date
1470: )
1471: is
1472: select payroll_id
1473: from pay_payrolls_f
1474: where business_group_id = c_business_group_id
1475: and period_type = 'Calendar Month'
1476: and c_effective_date
1477: between effective_start_date and effective_end_date;

Line 3506: pay_payrolls_f pay,

3502: cp_orig_effective_date date
3503: ) is
3504: select pay.period_type
3505: from per_all_assignments_f asg,
3506: pay_payrolls_f pay,
3507: per_all_assignments_f asg2,
3508: pay_payrolls_f pay2
3509: where asg.person_id = cp_person_id
3510: and asg.assignment_type <> 'C'

Line 3508: pay_payrolls_f pay2

3504: select pay.period_type
3505: from per_all_assignments_f asg,
3506: pay_payrolls_f pay,
3507: per_all_assignments_f asg2,
3508: pay_payrolls_f pay2
3509: where asg.person_id = cp_person_id
3510: and asg.assignment_type <> 'C'
3511: and asg.business_group_id = cp_business_group_id
3512: and asg.primary_flag = 'Y'

Line 8848: pay_payrolls_f pay,

8844: ---------Bug 7687104
8845: cursor c_chk_payroll_chg(p_rt_end_date date,p_payroll_id number)is
8846: select pay2.payroll_id old_payroll_id,pay.payroll_id new_payroll_id
8847: from per_all_assignments_f asg,
8848: pay_payrolls_f pay,
8849: per_all_assignments_f asg2,
8850: pay_payrolls_f pay2
8851: where asg.person_id = p_person_id
8852: and asg.business_group_id = p_business_group_id

Line 8850: pay_payrolls_f pay2

8846: select pay2.payroll_id old_payroll_id,pay.payroll_id new_payroll_id
8847: from per_all_assignments_f asg,
8848: pay_payrolls_f pay,
8849: per_all_assignments_f asg2,
8850: pay_payrolls_f pay2
8851: where asg.person_id = p_person_id
8852: and asg.business_group_id = p_business_group_id
8853: and asg.primary_flag = 'Y'
8854: and p_rt_end_date between