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 963: hr_general.decode_lookup('IN_STATES',loc_information16),

959: address_line_2,
960: address_line_3,
961: loc_information14,
962: loc_information15,
963: hr_general.decode_lookup('IN_STATES',loc_information16),
964: postal_code,
965: telephone_number_1,
966: telephone_number_2
967: FROM hr_locations

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

1362: IF p_form_type <> 'ESI6' and p_form_type <> 'PT3' AND p_form_type <> 'FORM27A' THEN
1363: l_effective_start_date:=to_date(('01-03-'||substr(p_contribution_period,1,4)),'DD-MM-YYYY');
1364: l_effective_end_date:= to_date(('01-03-'||substr(p_contribution_period,6)),'DD-MM-YYYY')-1;
1365: ELSE
1366: l_contribution_period := hr_general.decode_lookup('IN_ESI_CONTRIB_PERIOD',p_contribution_period);
1367: END IF;
1368:
1369: IF g_debug THEN
1370: pay_in_utils.trace('PF Organization id ',p_pf_org_id);

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

4700: SELECT fnd_date.CANONICAL_TO_DATE(org_information2) challan_date
4701: ,fnd_number.canonical_to_number(org_information3) challan_amt
4702: ,org_information5 challan_bank_code
4703: ,org_information6 challan_branch_code
4704: ,hr_general.decode_lookup('IN_ESI_BANKS',org_information5) challan_bank
4705: ,hr_general.decode_lookup('IN_CALENDAR_MONTH',org_information7) month
4706: FROM hr_organization_information
4707: WHERE organization_id=p_esi_org_id
4708: AND ORG_INFORMATION_CONTEXT='PER_IN_ESI_CHALLAN_INFO'

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

4701: ,fnd_number.canonical_to_number(org_information3) challan_amt
4702: ,org_information5 challan_bank_code
4703: ,org_information6 challan_branch_code
4704: ,hr_general.decode_lookup('IN_ESI_BANKS',org_information5) challan_bank
4705: ,hr_general.decode_lookup('IN_CALENDAR_MONTH',org_information7) month
4706: FROM hr_organization_information
4707: WHERE organization_id=p_esi_org_id
4708: AND ORG_INFORMATION_CONTEXT='PER_IN_ESI_CHALLAN_INFO'
4709: AND hr_general.decode_lookup('IN_ESI_CONTRIB_PERIOD',ORG_INFORMATION1)=p_contribution_period

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

4705: ,hr_general.decode_lookup('IN_CALENDAR_MONTH',org_information7) month
4706: FROM hr_organization_information
4707: WHERE organization_id=p_esi_org_id
4708: AND ORG_INFORMATION_CONTEXT='PER_IN_ESI_CHALLAN_INFO'
4709: AND hr_general.decode_lookup('IN_ESI_CONTRIB_PERIOD',ORG_INFORMATION1)=p_contribution_period
4710: ORDER BY fnd_date.CANONICAL_TO_DATE(org_information2) ASC;
4711:
4712: --Declaration Information
4713: CURSOR c_declaration(p_esi_org_id VARCHAR2)

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

4728: ,org_information12 wages_immd_emplr_not_covered
4729: FROM hr_organization_information
4730: WHERE organization_id = p_esi_org_id
4731: AND org_information_context = 'PER_IN_ESI_FORM5'
4732: AND hr_general.decode_lookup('IN_ESI_CONTRIB_PERIOD',org_information13) = p_contribution_period;
4733:
4734:
4735: --Elements computing the ESI Base Salary
4736: CURSOR c_elements