APPS.PAY_CA_RL2_MAG dependencies on HR_LOOKUPS

Line 1271: (select lookup_code from hr_lookups hl, fnd_sessions fs

1267: pay_ca_eoy_rl2_trans_info_v tran
1268: WHERE emp.assignment_action_id = p_asg_action_id
1269: AND emp.payroll_action_id = tran.payroll_action_id
1270: AND nvl(emp.rl2_source_of_income,1) not in --6525968
1271: (select lookup_code from hr_lookups hl, fnd_sessions fs
1272: where fs.session_id = USERENV('SESSIONID')
1273: and hl.lookup_type = 'PAY_CA_RL2_SOURCE_OF_INCOME'
1274: and (fs.effective_date > nvl(hl.end_date_active,to_date('31/12/4712','dd/mm/yyyy'))
1275: or hl.enabled_flag='N')

Line 1394: hr_lookups

1390: CURSOR cur_get_meaning(p_lookup_code VARCHAR2) IS
1391: SELECT
1392: meaning
1393: FROM
1394: hr_lookups
1395: WHERE
1396: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
1397: lookup_code = p_lookup_code;
1398:

Line 1399: l_meaning hr_lookups.meaning%TYPE;

1395: WHERE
1396: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
1397: lookup_code = p_lookup_code;
1398:
1399: l_meaning hr_lookups.meaning%TYPE;
1400: l_msg_code VARCHAR2(30);
1401: l_all_box_0 BOOLEAN;
1402:
1403: /* Cursor for fetching the Footnote Codes */

Line 1407: HR_LOOKUPS HL

1403: /* Cursor for fetching the Footnote Codes */
1404: CURSOR c_footnote_codes ( p_assg_actid number) is
1405: SELECT hl.meaning code, fnd_number.canonical_to_number(FT.FOOTNOTE_AMOUNT) value
1406: FROM PAY_CA_EOY_RL2_FOOTNOTE_INFO_V FT,
1407: HR_LOOKUPS HL
1408: WHERE FT.ASSIGNMENT_ACTION_ID = p_assg_actid
1409: AND ((HL.LOOKUP_TYPE = 'PAY_CA_RL2_FOOTNOTES'
1410: AND HL.lookup_code = FT.FOOTNOTE_CODE)
1411: OR