DBA Data[Home] [Help]

APPS.PAY_JP_SOE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 83: l_use_advanced_retropay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION4%TYPE;

79: l_entries_processed VARCHAR2(1);
80:
81: -- Added by Shashi
82: -- This is used to check the applicability of Advanced Retropay at Business Group Level
83: l_use_advanced_retropay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION4%TYPE;
84:
85: CURSOR csr_retro_entries_processed IS
86: select 'N'
87: from dual

Line 143: hr_organization_information org,

139:
140: SELECT NVL(org.org_information4, 'N')
141: INTO l_use_advanced_retropay
142: FROM pay_assignment_actions paa,
143: hr_organization_information org,
144: per_all_assignments asg
145: WHERE paa.assignment_action_id = p_creator_id
146: AND paa.assignment_id = asg.assignment_id
147: AND org.organization_id = asg.business_group_id