DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on HR_SOFT_CODING_KEYFLEX

Line 528: ,hr_soft_coding_keyflex HSCK

524: select HOI2.org_information1
525: from hr_organization_units HOU
526: ,hr_organization_information HOI1
527: ,hr_organization_information HOI2
528: ,hr_soft_coding_keyflex HSCK
529: ,per_all_assignments_f PAA
530: where HOU.business_group_id = PAA.business_group_id
531: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,
532: to_date('4712/12/31','YYYY/MM/DD'))

Line 634: ,hr_soft_coding_keyflex HSCK

630: select HOI2.org_information2
631: from hr_organization_units HOU
632: ,hr_organization_information HOI1
633: ,hr_organization_information HOI2
634: ,hr_soft_coding_keyflex HSCK
635: ,per_all_assignments_f PAA
636: where HOU.business_group_id = PAA.business_group_id
637: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,
638: to_date('4712/12/31','YYYY/MM/DD'))

Line 720: ,hr_soft_coding_keyflex HSCK

716: select HOI2.org_information3
717: from hr_organization_units HOU
718: ,hr_organization_information HOI1
719: ,hr_organization_information HOI2
720: ,hr_soft_coding_keyflex HSCK
721: ,per_all_assignments_f PAA
722: where HOU.business_group_id = PAA.business_group_id
723: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,
724: to_date('4712/12/31','YYYY/MM/DD'))

Line 840: ,hr_soft_coding_keyflex HSCK

836: select NVL(HOI2.org_information1,'X')
837: from hr_organization_units HOU
838: ,hr_organization_information HOI1
839: ,hr_organization_information HOI2
840: ,hr_soft_coding_keyflex HSCK
841: ,per_all_assignments_f PAA
842: where HOU.business_group_id = PAA.business_group_id
843: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,
844: to_date('4712/12/31','YYYY/MM/DD'))