APPS.PAY_CA_RL2_MAG dependencies on HR_LOOKUPS

Line 1315: l_err_msg hr_lookups.meaning%TYPE;

1311: l_final_xml BLOB;
1312: l_temp_blob BLOB;
1313: l_header_xml_string VARCHAR2(32000);
1314: l_trailer_xml VARCHAR2(32000);
1315: l_err_msg hr_lookups.meaning%TYPE;
1316: EOL varchar2(10);
1317:
1318: CURSOR c_payroll_asgid(p_arch_asact_id number) is
1319: select paa.payroll_action_id, paa.assignment_id

Line 1326: from hr_lookups

1322:
1323: /* To get error message */
1324: CURSOR cur_get_meaning(p_lookup_code VARCHAR2) IS
1325: select meaning
1326: from hr_lookups
1327: where
1328: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
1329: lookup_code = p_lookup_code;
1330:

Line 1767: hr_lookups hl

1763: CURSOR c_rl2_src_income(p_rl2_source_of_income varchar2, p_taxation_year varchar2) is
1764: select
1765: 'X'
1766: from
1767: hr_lookups hl
1768: where
1769: hl.lookup_type = 'PAY_CA_RL2_SOURCE_OF_INCOME'
1770: and trim(hl.lookup_code) = trim(p_rl2_source_of_income)
1771: 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 1894: hr_lookups

1890: CURSOR cur_get_meaning(p_lookup_code VARCHAR2) IS
1891: SELECT
1892: meaning
1893: FROM
1894: hr_lookups
1895: WHERE
1896: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
1897: lookup_code = p_lookup_code;
1898:

Line 1899: l_meaning hr_lookups.meaning%TYPE;

1895: WHERE
1896: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
1897: lookup_code = p_lookup_code;
1898:
1899: l_meaning hr_lookups.meaning%TYPE;
1900: l_msg_code VARCHAR2(30);
1901: l_all_box_0 BOOLEAN;
1902:
1903: /* Cursor for fetching the Footnote Codes */

Line 1907: HR_LOOKUPS HL

1903: /* Cursor for fetching the Footnote Codes */
1904: CURSOR c_footnote_codes ( p_assg_actid number) is
1905: SELECT hl.meaning code, fnd_number.canonical_to_number(FT.FOOTNOTE_AMOUNT) value
1906: FROM PAY_CA_EOY_RL2_FOOTNOTE_INFO_V FT,
1907: HR_LOOKUPS HL
1908: WHERE FT.ASSIGNMENT_ACTION_ID = p_assg_actid
1909: AND ((HL.LOOKUP_TYPE = 'PAY_CA_RL2_FOOTNOTES'
1910: AND HL.lookup_code = FT.FOOTNOTE_CODE)
1911: OR

Line 1918: FROM hr_lookups

1914:
1915: /* Cursor for fetching authorisation code */
1916: CURSOR c_get_auth_code(p_reporting_year varchar2) IS
1917: SELECT meaning
1918: FROM hr_lookups
1919: WHERE trim(lookup_code) = p_reporting_year
1920: AND lookup_type = 'PAY_CA_RL2_PDF_AUTH'
1921: AND enabled_flag='Y';
1922: