DBA Data[Home] [Help]

APPS.PAY_FR_RUN_TYPES dependencies on PAY_ELEMENT_TYPES_F

Line 35: pay_element_types_f pet,

31: pet.legislation_code,
32: pet.indirect_only_flag,
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

Line 439: From pay_element_types_f pet

435: ,pet.element_name
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'

Line 455: From pay_element_types_f pet

451: ,pet.element_name
452: ,pet.business_group_id
453: ,pet.legislation_code
454: ,Min(pet.effective_start_date) effective_date
455: From pay_element_types_f pet
456: Where Nvl(pet.indirect_only_flag, 'N') = 'N'
457: And pet.legislation_code = 'FR'
458: And pet.business_group_id Is Null
459: Group By pet.element_type_id,