DBA Data[Home] [Help]

APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on HR_ORGANIZATION_INFORMATION

Line 6380: from pay_user_columns puc, hr_organization_information hoi

6376: where cagr_grade_def_id = p_cagr_grade_def_id;
6377:
6378: cursor csr_default_work_schedule(leg_code in varchar2) is
6379: select to_char(user_column_id)
6380: from pay_user_columns puc, hr_organization_information hoi
6381: WHERE (HOI.org_information1 = to_char(PUC.user_table_id)
6382: OR HOI.org_information1 is null )
6383: AND HOI.org_information_context = 'Work Schedule'
6384: AND HOI.organization_id = p_organization_id

Line 6394: from pay_user_columns puc, hr_organization_information hoi

6390:
6391: /*cursor csr_validate_work_schedule(leg_code in varchar2,
6392: segment4 in number) is
6393: select to_char(user_column_id)
6394: from pay_user_columns puc, hr_organization_information hoi
6395: WHERE (HOI.org_information1 = to_char(PUC.user_table_id)
6396: OR HOI.org_information1 is null )
6397: AND HOI.org_information_context = 'Work Schedule'
6398: AND HOI.organization_id = p_organization_id