DBA Data[Home] [Help]

APPS.BEN_ELECTION_INFORMATION dependencies on PAY_PAYROLLS_F

Line 1462: pay_payrolls_f pay,

1458: cp_orig_effective_date date
1459: ) is
1460: select pay.period_type
1461: from per_all_assignments_f asg,
1462: pay_payrolls_f pay,
1463: per_all_assignments_f asg2,
1464: pay_payrolls_f pay2
1465: where asg.person_id = cp_person_id
1466: and asg.assignment_type <> 'C'

Line 1464: pay_payrolls_f pay2

1460: select pay.period_type
1461: from per_all_assignments_f asg,
1462: pay_payrolls_f pay,
1463: per_all_assignments_f asg2,
1464: pay_payrolls_f pay2
1465: where asg.person_id = cp_person_id
1466: and asg.assignment_type <> 'C'
1467: and asg.business_group_id = cp_business_group_id
1468: and asg.primary_flag = 'Y'