DBA Data[Home] [Help]

APPS.BEN_ELECTION_INFORMATION dependencies on PAY_PAYROLLS_F

Line 1280: pay_payrolls_f pay,

1276: cp_orig_effective_date date
1277: ) is
1278: select pay.period_type
1279: from per_all_assignments_f asg,
1280: pay_payrolls_f pay,
1281: per_all_assignments_f asg2,
1282: pay_payrolls_f pay2
1283: where asg.person_id = cp_person_id
1284: and asg.assignment_type <> 'C'

Line 1282: pay_payrolls_f pay2

1278: select pay.period_type
1279: from per_all_assignments_f asg,
1280: pay_payrolls_f pay,
1281: per_all_assignments_f asg2,
1282: pay_payrolls_f pay2
1283: where asg.person_id = cp_person_id
1284: and asg.assignment_type <> 'C'
1285: and asg.business_group_id = cp_business_group_id
1286: and asg.primary_flag = 'Y'