eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_REPORTS_PKG dependencies on HR_GENERAL

Line 1043: hr_general.decode_lookup('IN_STATES',loc_information16),

1039: address_line_2,
1040: address_line_3,
1041: loc_information14,
1042: loc_information15,
1043: hr_general.decode_lookup('IN_STATES',loc_information16),
1044: postal_code,
1045: telephone_number_1,
1046: telephone_number_2
1047: FROM hr_locations

Line 1941: l_contribution_period := hr_general.decode_lookup('IN_ESI_CONTRIB_PERIOD',p_contribution_period);

1937: IF p_form_type <> 'ESI6' and p_form_type <> 'PT3' AND p_form_type <> 'FORM27A' THEN
1938: l_effective_start_date:=to_date(('01-03-'||substr(p_contribution_period,1,4)),'DD-MM-YYYY');
1939: l_effective_end_date:= to_date(('01-03-'||substr(p_contribution_period,6)),'DD-MM-YYYY')-1;
1940: ELSE
1941: l_contribution_period := hr_general.decode_lookup('IN_ESI_CONTRIB_PERIOD',p_contribution_period);
1942: END IF;
1943:
1944: IF g_debug THEN
1945: pay_in_utils.trace('PF Organization id ',p_pf_org_id);

Line 5423: ,hr_general.decode_lookup('IN_ESI_BANKS',org_information5) challan_bank

5419: SELECT fnd_date.CANONICAL_TO_DATE(org_information2) challan_date
5420: ,fnd_number.canonical_to_number(org_information3) challan_amt
5421: ,org_information5 challan_bank_code
5422: ,org_information6 challan_branch_code
5423: ,hr_general.decode_lookup('IN_ESI_BANKS',org_information5) challan_bank
5424: ,hr_general.decode_lookup('IN_CALENDAR_MONTH',org_information7) month
5425: FROM hr_organization_information
5426: WHERE organization_id=p_esi_org_id
5427: AND ORG_INFORMATION_CONTEXT='PER_IN_ESI_CHALLAN_INFO'

Line 5424: ,hr_general.decode_lookup('IN_CALENDAR_MONTH',org_information7) month

5420: ,fnd_number.canonical_to_number(org_information3) challan_amt
5421: ,org_information5 challan_bank_code
5422: ,org_information6 challan_branch_code
5423: ,hr_general.decode_lookup('IN_ESI_BANKS',org_information5) challan_bank
5424: ,hr_general.decode_lookup('IN_CALENDAR_MONTH',org_information7) month
5425: FROM hr_organization_information
5426: WHERE organization_id=p_esi_org_id
5427: AND ORG_INFORMATION_CONTEXT='PER_IN_ESI_CHALLAN_INFO'
5428: AND hr_general.decode_lookup('IN_ESI_CONTRIB_PERIOD',ORG_INFORMATION1)=p_contribution_period

Line 5428: AND hr_general.decode_lookup('IN_ESI_CONTRIB_PERIOD',ORG_INFORMATION1)=p_contribution_period

5424: ,hr_general.decode_lookup('IN_CALENDAR_MONTH',org_information7) month
5425: FROM hr_organization_information
5426: WHERE organization_id=p_esi_org_id
5427: AND ORG_INFORMATION_CONTEXT='PER_IN_ESI_CHALLAN_INFO'
5428: AND hr_general.decode_lookup('IN_ESI_CONTRIB_PERIOD',ORG_INFORMATION1)=p_contribution_period
5429: ORDER BY fnd_date.CANONICAL_TO_DATE(org_information2) ASC;
5430:
5431: --Declaration Information
5432: CURSOR c_declaration(p_esi_org_id VARCHAR2)

Line 5451: AND hr_general.decode_lookup('IN_ESI_CONTRIB_PERIOD',org_information13) = p_contribution_period;

5447: ,org_information12 wages_immd_emplr_not_covered
5448: FROM hr_organization_information
5449: WHERE organization_id = p_esi_org_id
5450: AND org_information_context = 'PER_IN_ESI_FORM5'
5451: AND hr_general.decode_lookup('IN_ESI_CONTRIB_PERIOD',org_information13) = p_contribution_period;
5452:
5453:
5454: --Elements computing the ESI Base Salary
5455: CURSOR c_elements