DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PER_BUSINESS_GROUPS

Line 951: from per_business_groups

947: *****************************************************************/
948:
949: cursor c_get_localization(cp_assignment_id in number) is
950: select legislation_code
951: from per_business_groups
952: where business_group_id in
953: (select business_group_id
954: from per_all_people_f
955: where person_id in

Line 1596: from per_business_groups pbg,

1592: decode(pbg.frequency, 'Y', 1,
1593: 'M', 12,
1594: 'W', 52,
1595: 'D', 365, 1)
1596: from per_business_groups pbg,
1597: per_assignments_f paf
1598: where paf.assignment_id = cp_assignment_id
1599: and cp_period_end_date between paf.effective_start_date
1600: and paf.effective_end_date