APPS.PAY_CA_RL2_AMEND_MAG dependencies on HR_LOOKUPS

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

1425: WHERE emp.assignment_action_id = p_asg_action_id
1426: AND emp.payroll_action_id = tran.payroll_action_id;
1427: /* Commented for bug 8888411
1428: AND nvl(emp.rl2_source_of_income,1) not in --6525968
1429: (select lookup_code from hr_lookups hl, fnd_sessions fs
1430: where fs.session_id = USERENV('SESSIONID')
1431: and hl.lookup_type = 'PAY_CA_RL2_SOURCE_OF_INCOME'
1432: and (fs.effective_date > nvl(hl.end_date_active,to_date('31/12/4712','dd/mm/yyyy'))
1433: or hl.enabled_flag='N')

Line 1442: hr_lookups hl

1438: CURSOR c_rl2_src_income(p_rl2_source_of_income varchar2, p_taxation_year varchar2) is
1439: select
1440: 'X'
1441: from
1442: hr_lookups hl
1443: where
1444: hl.lookup_type = 'PAY_CA_RL2_SOURCE_OF_INCOME'
1445: and trim(hl.lookup_code) = trim(p_rl2_source_of_income)
1446: 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 1578: hr_lookups

1574: CURSOR cur_get_meaning(p_lookup_code VARCHAR2) IS
1575: SELECT
1576: meaning
1577: FROM
1578: hr_lookups
1579: WHERE
1580: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
1581: lookup_code = p_lookup_code;
1582:

Line 1583: l_meaning hr_lookups.meaning%TYPE;

1579: WHERE
1580: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
1581: lookup_code = p_lookup_code;
1582:
1583: l_meaning hr_lookups.meaning%TYPE;
1584: l_msg_code VARCHAR2(30);
1585: l_all_box_0 BOOLEAN;
1586:
1587: /* Cursor for fetching the Footnote Codes */

Line 1591: HR_LOOKUPS HL

1587: /* Cursor for fetching the Footnote Codes */
1588: CURSOR c_footnote_codes ( p_assg_actid number) is
1589: SELECT hl.meaning code, fnd_number.canonical_to_number(FT.FOOTNOTE_AMOUNT) value
1590: FROM PAY_CA_EOY_RL2_FOOTNOTE_INFO_V FT,
1591: HR_LOOKUPS HL
1592: WHERE FT.ASSIGNMENT_ACTION_ID = p_assg_actid
1593: AND ((HL.LOOKUP_TYPE = 'PAY_CA_RL2_FOOTNOTES'
1594: AND HL.lookup_code = FT.FOOTNOTE_CODE)
1595: OR

Line 1613: FROM hr_lookups

1609:
1610: /* Cursor for fetching authorisation code */
1611: CURSOR c_get_auth_code(p_reporting_year varchar2) IS
1612: SELECT meaning
1613: FROM hr_lookups
1614: WHERE trim(lookup_code) = p_reporting_year
1615: AND lookup_type = 'PAY_CA_RL2_PDF_AUTH'
1616: AND enabled_flag='Y';
1617: