DBA Data[Home] [Help]

APPS.PAY_IP_ELE_INFO_CAT_UPG dependencies on PER_BUSINESS_GROUPS

Line 69: per_business_groups pbg,

65:
66: CURSOR csr_qualified IS
67: SELECT 'Y'
68: FROM pay_element_types_f pet,
69: per_business_groups pbg,
70: hr_legislation_installations hli
71: WHERE pet.element_type_id = p_object_id
72: AND pbg.business_group_id = pet.business_group_id
73: AND pbg.legislation_code = hli.legislation_code;

Line 155: per_business_groups pbg

151: SELECT upper(pbg.legislation_code),
152: upper(pec.classification_name)
153: FROM pay_element_types_f pet,
154: pay_element_classifications pec,
155: per_business_groups pbg
156: WHERE pet.element_type_id = p_object_id
157: AND pbg.business_group_id = pet.business_group_id
158: AND pec.classification_id = pet.classification_id
159: AND rownum = 1;