DBA Data[Home] [Help]

APPS.BEN_ELEMENT_ENTRY dependencies on PAY_PAYROLLS_F

Line 1472: from pay_payrolls_f

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

Line 3280: pay_payrolls_f pay,

3276: cp_orig_effective_date date
3277: ) is
3278: select pay.period_type
3279: from per_all_assignments_f asg,
3280: pay_payrolls_f pay,
3281: per_all_assignments_f asg2,
3282: pay_payrolls_f pay2
3283: where asg.person_id = cp_person_id
3284: and asg.assignment_type <> 'C'

Line 3282: pay_payrolls_f pay2

3278: select pay.period_type
3279: from per_all_assignments_f asg,
3280: pay_payrolls_f pay,
3281: per_all_assignments_f asg2,
3282: pay_payrolls_f pay2
3283: where asg.person_id = cp_person_id
3284: and asg.assignment_type <> 'C'
3285: and asg.business_group_id = cp_business_group_id
3286: and asg.primary_flag = 'Y'