DBA Data[Home] [Help]

APPS.BEN_DETERMINE_RATE_CHG dependencies on PAY_PAYROLLS_F

Line 607: pay_payrolls_f pay,

603: cp_orig_effective_date date
604: ) is
605: select pay.period_type
606: from per_all_assignments_f asg,
607: pay_payrolls_f pay,
608: per_all_assignments_f asg2,
609: pay_payrolls_f pay2
610: where asg.person_id = cp_person_id
611: and asg.assignment_type <> 'C'

Line 609: pay_payrolls_f pay2

605: select pay.period_type
606: from per_all_assignments_f asg,
607: pay_payrolls_f pay,
608: per_all_assignments_f asg2,
609: pay_payrolls_f pay2
610: where asg.person_id = cp_person_id
611: and asg.assignment_type <> 'C'
612: and asg.business_group_id = cp_business_group_id
613: and asg.primary_flag = 'Y'