DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on HR_ORGANIZATION_INFORMATION

Line 101: hr_organization_information where organization_id = p_business_group_id

97: AND enabled_flag = 'Y')
98: NATIONALITY_DESC,
99: NATIONAL_IDENTIFIER,
100: (select message_text from fnd_new_messages where message_name = 'HR_NATIONAL_ID_NUMBER_'|| (select to_char(org_information9) from
101: hr_organization_information where organization_id = p_business_group_id
102: and org_information_context = 'Business Group Information')
103: and language_code = USERENV('LANG') ) NATIONAL_ID_LABEL,
104: OFFICE_NUMBER,
105: ON_MILITARY_SERVICE,

Line 1497: hr_organization_information where organization_id = p_bus_grp_id

1493: p_pyrl_action_id pay_payroll_actions.payroll_action_id%type;
1494:
1495: cursor csr_leg_code(p_bus_grp_id number) is
1496: select to_char(org_information9) from
1497: hr_organization_information where organization_id = p_bus_grp_id
1498: and org_information_context = 'Business Group Information';
1499:
1500: --Declaration for Payroll - ends here
1501: