DBA Data[Home] [Help]

APPS.PAY_FR_RUN_TYPES dependencies on PER_BUSINESS_GROUPS

Line 37: per_business_groups pbg

33: min(pet.effective_start_date) effective_date
34: From
35: pay_element_types_f pet,
36: pay_element_classifications pec,
37: per_business_groups pbg
38: Where
39: pet.element_type_id = c_element_type_id
40: and pet.classification_id = pec.classification_id
41: and nvl(pet.business_group_id,pbg.business_group_id) = pbg.business_group_id

Line 440: ,per_business_groups pbg

436: ,pet.business_group_id
437: ,pet.legislation_code
438: ,Min(pet.effective_start_date) effective_date
439: From pay_element_types_f pet
440: ,per_business_groups pbg
441: Where Nvl(pet.indirect_only_flag, 'N') = 'N'
442: And pbg.business_group_id = pet.business_group_id
443: And pbg.legislation_code = 'FR'
444: And pet.legislation_code Is Null