DBA Data[Home] [Help]

APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on HR_ORGANIZATION_INFORMATION

Line 6710: from pay_user_columns puc, hr_organization_information hoi

6706: where cagr_grade_def_id = p_cagr_grade_def_id;
6707:
6708: cursor csr_default_work_schedule(leg_code in varchar2) is
6709: select to_char(user_column_id)
6710: from pay_user_columns puc, hr_organization_information hoi
6711: WHERE (HOI.org_information1 = to_char(PUC.user_table_id)
6712: OR HOI.org_information1 is null )
6713: AND HOI.org_information_context = 'Work Schedule'
6714: AND HOI.organization_id = p_organization_id

Line 6724: from pay_user_columns puc, hr_organization_information hoi

6720:
6721: /*cursor csr_validate_work_schedule(leg_code in varchar2,
6722: segment4 in number) is
6723: select to_char(user_column_id)
6724: from pay_user_columns puc, hr_organization_information hoi
6725: WHERE (HOI.org_information1 = to_char(PUC.user_table_id)
6726: OR HOI.org_information1 is null )
6727: AND HOI.org_information_context = 'Work Schedule'
6728: AND HOI.organization_id = p_organization_id