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_ORGANIZATION_INFORMATION

Line 478: FROM hr_organization_information

474: IS
475: SELECT NVL(SUM(fnd_number.canonical_to_number(org_information5)),0) challan_amt
476: ,NVL(SUM(fnd_number.canonical_to_number(org_information6)),0) interest_amt
477: ,NVL(SUM(fnd_number.canonical_to_number(org_information8)),0) excess_amt
478: FROM hr_organization_information
479: WHERE organization_id = p_pt_org_id
480: AND org_information_context = 'PER_IN_PT_CHALLAN_INFO'
481: AND ADD_MONTHS(TO_DATE('01-'|| org_information1 || SUBSTR(org_information9, 1, 4), 'DD-MM-YYYY'), 3)
482: BETWEEN p_period_start AND p_period_end;

Line 549: l_registered_no hr_organization_information.org_information1%TYPE;

545: l_reg_address VARCHAR2(240);
546: period_start DATE;
547: period_end DATE;
548: l_date DATE;
549: l_registered_no hr_organization_information.org_information1%TYPE;
550: l_registered_name hr_organization_units.name%TYPE;
551: l_rep_name per_all_people_f.full_name%TYPE;
552: l_rep_desg per_all_positions.name%TYPE;
553: l_org_name hr_organization_units.name%TYPE;

Line 1604: FROM hr_organization_information

1600: ,p_effective_end_date DATE)
1601: IS
1602: SELECT fnd_number.canonical_to_number(org_information2) mon --Month Number
1603: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
1604: FROM hr_organization_information
1605: WHERE organization_id = p_pf_org_id
1606: AND ORG_INFORMATION_CONTEXT = 'PER_IN_PF_CHALLAN_INFO'
1607: AND org_information1=TO_CHAR(p_effective_start_date,'YYYY')||'-'||TO_CHAR(p_effective_end_date,'YYYY')
1608: GROUP BY org_information2

Line 2084: hr_organization_information target

2080: CURSOR c_emplr_class is
2081: SELECT target.org_information3
2082: FROM per_assignments_f assign,
2083: hr_soft_coding_keyflex scl,
2084: hr_organization_information target
2085: WHERE assign.assignment_id = p_assignment_id
2086: AND p_earn_date BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date
2087: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2088: AND scl.segment1 = target.organization_id

Line 2101: l_emplr_class hr_organization_information.org_information3%TYPE;

2097: AND assign.assignment_id = p_assignment_id
2098: AND service.period_of_service_id (+)= assign.period_of_service_id;
2099:
2100: l_disable_proof per_disabilities_f.dis_information1%TYPE;
2101: l_emplr_class hr_organization_information.org_information3%TYPE;
2102: l_hire_date date;
2103: l_ceiling_type varchar2(50);
2104:
2105: --

Line 2674: FROM hr_organization_information

2670: ,SUM(fnd_number.canonical_to_number(org_information6)) dli --DLI Contribution A/c No.21
2671: ,SUM(fnd_number.canonical_to_number(org_information7)) edli --EDLI ADM. Charges A/c No.22
2672: ,SUM(fnd_number.canonical_to_number(org_information8)) admin --Adm. Charges A/c No.2
2673: ,SUM(fnd_number.canonical_to_number(org_information6)+fnd_number.canonical_to_number(org_information7)+fnd_number.canonical_to_number(org_information8)) agg
2674: FROM hr_organization_information
2675: WHERE organization_id=p_pf_org_id
2676: AND ORG_INFORMATION_CONTEXT='PER_IN_PF_CHALLAN_INFO'
2677: AND org_information1=to_char(p_effective_start_date,'YYYY')||'-'||to_char(p_effective_end_date,'YYYY')
2678: AND org_information2=to_number(TO_CHAR(TO_DATE('01-03-2004','DD-MM-YYYY'),'MM'))+decode(i,0,9,-3+i)

Line 3635: ,hr_organization_information hoi

3631: CURSOR csr_exempted_pf_orglist
3632: IS
3633: SELECT hou.organization_id orgid
3634: FROM hr_all_organization_units hou
3635: ,hr_organization_information hoi
3636: WHERE hou.organization_id = hoi.organization_id
3637: AND hoi.org_information_context ='PER_IN_PF_DF'
3638: AND hou.organization_id like nvl(p_pf_org_id,'%')
3639: AND hou.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')

Line 3773: l_reg_name hr_organization_information.org_information1%TYPE;

3769: AND p_effective_end_date BETWEEN glb.effective_start_date and glb.effective_end_date;
3770:
3771:
3772:
3773: l_reg_name hr_organization_information.org_information1%TYPE;
3774: l_rep_name per_all_people_f.full_name%TYPE;
3775: l_org_address pay_action_information.action_information1%TYPE;
3776: --In the Rarest case of location adddress exceeding 240 characters nothing can be done
3777: l_est_code hr_organization_information.org_information1%TYPE;

Line 3777: l_est_code hr_organization_information.org_information1%TYPE;

3773: l_reg_name hr_organization_information.org_information1%TYPE;
3774: l_rep_name per_all_people_f.full_name%TYPE;
3775: l_org_address pay_action_information.action_information1%TYPE;
3776: --In the Rarest case of location adddress exceeding 240 characters nothing can be done
3777: l_est_code hr_organization_information.org_information1%TYPE;
3778:
3779: g_org_XMLTable pay_in_xml_utils.tXMLTable;
3780:
3781: l_employee_name per_all_people_f.full_name%TYPE;

Line 4706: FROM hr_organization_information

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
4710: ORDER BY fnd_date.CANONICAL_TO_DATE(org_information2) ASC;

Line 4729: FROM hr_organization_information

4725: ,TO_NUMBER(org_information9) immediate_employer_covered
4726: ,org_information10 wages_immediate_emplr_covered
4727: ,TO_NUMBER(org_information11) immediate_emplr_not_covered
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:

Line 4762: ,hr_organization_information hoi

4758: IS
4759: SELECT hoi.org_information3 branch_name
4760: ,hoi.org_information4 branch_add
4761: FROM hr_organization_units hou
4762: ,hr_organization_information hoi
4763: WHERE hoi.organization_id = hou.organization_id
4764: AND hoi.org_information_context = 'PER_IN_ESI_BANK_BRANCH_DTLS'
4765: AND hou.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
4766: AND hoi.org_information1 = p_bank_code

Line 4797: l_employer_code hr_organization_information.org_information1%TYPE;

4793: l_bg_id NUMBER;
4794: l_payroll DATE;
4795: l_tag VARCHAR2(1000);
4796: l_payroll_act_id NUMBER;
4797: l_employer_code hr_organization_information.org_information1%TYPE;
4798: l_registered_name hr_organization_units.name%TYPE;
4799: l_reg_address VARCHAR2(240);
4800: l_rep_name per_all_people_f.full_name%TYPE;
4801: l_rep_desg per_all_positions.name%TYPE;