DBA Data[Home] [Help]

APPS.GHR_PAR_BUS dependencies on GHR_NOAC_LAS

Line 906: ghr_noac_las nla

902: cursor c_la_code is
903: select hl.lookup_code ,
904: hl.meaning
905: from hr_lookups hl ,
906: ghr_noac_las nla
907: where nla.nature_of_action_id = p_first_nature_of_action_id
908: and SUBSTR(nla.lac_lookup_code,1,3) = p_first_action_la_code1
909: and nla.valid_first_lac_flag = 'Y'
910: and hl.lookup_type = 'GHR_US_LEGAL_AUTHORITY'

Line 983: ghr_noac_las nla

979: cursor c_la_code is
980: select hl.lookup_code ,
981: hl.meaning
982: from hr_lookups hl,
983: ghr_noac_las nla
984: where nla.nature_of_action_id = p_first_nature_of_action_id
985: and SUBSTR(nla.lac_lookup_code,1,3) = p_first_action_la_code2
986: and nla.valid_second_lac_flag = 'Y'
987: and hl.lookup_type = 'GHR_US_LEGAL_AUTHORITY'

Line 1160: ghr_noac_las nla

1156: cursor c_la_code is
1157: select hl.lookup_code ,
1158: hl.meaning
1159: from hr_lookups hl ,
1160: ghr_noac_las nla
1161: where nla.nature_of_action_id = p_second_nature_of_action_id
1162: and SUBSTR(nla.lac_lookup_code,1,3) = p_second_action_la_code1
1163: and nla.valid_first_lac_flag = 'Y'
1164: and hl.lookup_type = 'GHR_US_LEGAL_AUTHORITY'

Line 1237: ghr_noac_las nla

1233: cursor c_la_code is
1234: select hl.lookup_code ,
1235: hl.meaning
1236: from hr_lookups hl ,
1237: ghr_noac_las nla
1238: where nla.nature_of_action_id = p_second_nature_of_action_id
1239: and substr(nla.lac_lookup_code,1,3) = p_second_action_la_code2
1240: and nla.valid_second_lac_flag = 'Y'
1241: and hl.lookup_type = 'GHR_US_LEGAL_AUTHORITY'