DBA Data[Home] [Help]

APPS.PER_PYP_BUS dependencies on PER_BUSINESS_GROUPS

Line 1609: l_bus_working_hours_frequency per_business_groups.frequency%TYPE;

1605: l_normal_hours_frequency per_all_assignments_f.frequency%TYPE;
1606: l_org_working_hours NUMBER;
1607: l_org_working_hours_frequency per_organization_units.frequency%TYPE;
1608: l_bus_working_hours NUMBER;
1609: l_bus_working_hours_frequency per_business_groups.frequency%TYPE;
1610: l_pyp_working_hours hr_all_positions_f.working_hours%TYPE;
1611: l_pyp_working_hours_frequency hr_all_positions_f.frequency%TYPE;
1612: l_minimum NUMBER;
1613: l_maximum NUMBER;

Line 3323: from per_business_groups pbg

3319: -- Cursor to find legislation code
3320: --
3321: cursor csr_leg_code is
3322: select pbg.legislation_code
3323: from per_business_groups pbg
3324: , per_pay_proposals pyp
3325: where pyp.pay_proposal_id = p_pay_proposal_id
3326: and pbg.business_group_id = pyp.business_group_id;
3327: --