DBA Data[Home] [Help]

APPS.HR_FI_UTILITY dependencies on HR_SOFT_CODING_KEYFLEX

Line 366: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups

362: where assignment_id = p_assignment_id;
363:
364: cursor get_info_from_scl is
365: select lookups.meaning
366: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups
367: where scl.SOFT_CODING_KEYFLEX_ID = l_scl_id
368: and lookups.lookup_type=l_information_code
369: and lookups.enabled_flag = 'Y'
370: and lookups.lookup_code = decode(l_information_code,'FI_EMPLOYMENT_TYPE',scl.segment3,

Line 383: from hr_soft_coding_keyflex

379:
380:
381: cursor get_local_unit is
382: select segment2
383: from hr_soft_coding_keyflex
384: where soft_coding_keyflex_id = l_scl_id;
385:
386:
387: cursor get_info_from_local_unit is

Line 693: csr_v_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE

689: lr_chk_reasons csr_chk_contract_reasons%ROWTYPE;
690:
691:
692: CURSOR csr_soft_coded_keyflex_info (
693: csr_v_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE
694: ) IS
695: SELECT SEGMENT3 l_Employment_Type,
696: SEGMENT4 l_Working_Time_Type
697: FROM hr_soft_coding_keyflex

Line 697: FROM hr_soft_coding_keyflex

693: csr_v_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE
694: ) IS
695: SELECT SEGMENT3 l_Employment_Type,
696: SEGMENT4 l_Working_Time_Type
697: FROM hr_soft_coding_keyflex
698: WHERE soft_coding_keyflex_id = csr_v_soft_coding_keyflex_id;
699:
700: lr_soft_coded_keyflex_info csr_soft_coded_keyflex_info%ROWTYPE;
701: