APPS.PAY_CA_RL2_CAN_MAG dependencies on HR_LOOKUPS

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

1449: emp.assignment_action_id = p_asg_action_id
1450: AND emp.payroll_action_id = tran.payroll_action_id;
1451: /* Commented for bug 8888411
1452: AND nvl(emp.rl2_source_of_income,1) not in --6525968
1453: (select lookup_code from hr_lookups hl, fnd_sessions fs
1454: where fs.session_id = USERENV('SESSIONID')
1455: and hl.lookup_type = 'PAY_CA_RL2_SOURCE_OF_INCOME'
1456: and (fs.effective_date > nvl(hl.end_date_active,to_date('31/12/4712','dd/mm/yyyy'))
1457: or hl.enabled_flag='N')

Line 1466: hr_lookups hl

1462: CURSOR c_rl2_src_income(p_rl2_source_of_income varchar2, p_taxation_year varchar2) is
1463: select
1464: 'X'
1465: from
1466: hr_lookups hl
1467: where
1468: hl.lookup_type = 'PAY_CA_RL2_SOURCE_OF_INCOME'
1469: and trim(hl.lookup_code) = trim(p_rl2_source_of_income)
1470: and to_date('31/12/'||p_taxation_year,'dd/mm/yyyy')<= nvl(hl.end_date_active,to_date('31/12/4712','dd/mm/yyyy'))

Line 1589: hr_lookups

1585: CURSOR cur_get_meaning(p_lookup_code VARCHAR2) IS
1586: SELECT
1587: meaning
1588: FROM
1589: hr_lookups
1590: WHERE
1591: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
1592: lookup_code = p_lookup_code;
1593:

Line 1594: l_meaning hr_lookups.meaning%TYPE;

1590: WHERE
1591: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
1592: lookup_code = p_lookup_code;
1593:
1594: l_meaning hr_lookups.meaning%TYPE;
1595: l_msg_code VARCHAR2(30);
1596: l_all_box_0 BOOLEAN;
1597:
1598: /* Cursor for fetching the Footnote Codes */

Line 1602: HR_LOOKUPS HL

1598: /* Cursor for fetching the Footnote Codes */
1599: CURSOR c_footnote_codes ( p_assg_actid number) is
1600: SELECT hl.meaning code, fnd_number.canonical_to_number(FT.FOOTNOTE_AMOUNT) value
1601: FROM PAY_CA_EOY_RL2_FOOTNOTE_INFO_V FT,
1602: HR_LOOKUPS HL
1603: WHERE FT.ASSIGNMENT_ACTION_ID = p_assg_actid
1604: AND ((HL.LOOKUP_TYPE = 'PAY_CA_RL2_FOOTNOTES'
1605: AND HL.lookup_code = FT.FOOTNOTE_CODE)
1606: OR