DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on HR_SOFT_CODING_KEYFLEX

Line 594: ,hr_soft_coding_keyflex HSCK

590: select HOI2.org_information1
591: from hr_organization_units HOU
592: ,hr_organization_information HOI1
593: ,hr_organization_information HOI2
594: ,hr_soft_coding_keyflex HSCK
595: ,per_all_assignments_f PAA
596: where HOU.business_group_id = PAA.business_group_id
597: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,
598: to_date('4712/12/31','YYYY/MM/DD'))

Line 700: ,hr_soft_coding_keyflex HSCK

696: select HOI2.org_information2
697: from hr_organization_units HOU
698: ,hr_organization_information HOI1
699: ,hr_organization_information HOI2
700: ,hr_soft_coding_keyflex HSCK
701: ,per_all_assignments_f PAA
702: where HOU.business_group_id = PAA.business_group_id
703: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,
704: to_date('4712/12/31','YYYY/MM/DD'))

Line 786: ,hr_soft_coding_keyflex HSCK

782: select HOI2.org_information3
783: from hr_organization_units HOU
784: ,hr_organization_information HOI1
785: ,hr_organization_information HOI2
786: ,hr_soft_coding_keyflex HSCK
787: ,per_all_assignments_f PAA
788: where HOU.business_group_id = PAA.business_group_id
789: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,
790: to_date('4712/12/31','YYYY/MM/DD'))

Line 906: ,hr_soft_coding_keyflex HSCK

902: select NVL(HOI2.org_information1,'X')
903: from hr_organization_units HOU
904: ,hr_organization_information HOI1
905: ,hr_organization_information HOI2
906: ,hr_soft_coding_keyflex HSCK
907: ,per_all_assignments_f PAA
908: where HOU.business_group_id = PAA.business_group_id
909: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,
910: to_date('4712/12/31','YYYY/MM/DD'))