DBA Data[Home] [Help]

APPS.BEN_DETERMINE_RATE_CHG dependencies on PAY_PAYROLLS_F

Line 655: pay_payrolls_f pay,

651: cp_orig_effective_date date
652: ) is
653: select pay.period_type
654: from per_all_assignments_f asg,
655: pay_payrolls_f pay,
656: per_all_assignments_f asg2,
657: pay_payrolls_f pay2
658: where asg.person_id = cp_person_id
659: and asg.assignment_type <> 'C'

Line 657: pay_payrolls_f pay2

653: select pay.period_type
654: from per_all_assignments_f asg,
655: pay_payrolls_f pay,
656: per_all_assignments_f asg2,
657: pay_payrolls_f pay2
658: where asg.person_id = cp_person_id
659: and asg.assignment_type <> 'C'
660: and asg.business_group_id = cp_business_group_id
661: and asg.primary_flag = 'Y'