DBA Data[Home] [Help]

APPS.PER_PYP_BUS dependencies on PER_BUSINESS_GROUPS

Line 1719: l_bus_working_hours_frequency per_business_groups.frequency%TYPE;

1715: l_normal_hours_frequency per_all_assignments_f.frequency%TYPE;
1716: l_org_working_hours NUMBER;
1717: l_org_working_hours_frequency per_organization_units.frequency%TYPE;
1718: l_bus_working_hours NUMBER;
1719: l_bus_working_hours_frequency per_business_groups.frequency%TYPE;
1720: l_pyp_working_hours hr_all_positions_f.working_hours%TYPE;
1721: l_pyp_working_hours_frequency hr_all_positions_f.frequency%TYPE;
1722: l_minimum NUMBER;
1723: l_maximum NUMBER;

Line 3466: from per_business_groups pbg

3462: -- Cursor to find legislation code
3463: --
3464: cursor csr_leg_code is
3465: select pbg.legislation_code
3466: from per_business_groups pbg
3467: , per_pay_proposals pyp
3468: where pyp.pay_proposal_id = p_pay_proposal_id
3469: and pbg.business_group_id = pyp.business_group_id;
3470: --