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 566: l_registered_no hr_organization_information.org_information1%TYPE;

562: l_reg_address VARCHAR2(240);
563: period_start DATE;
564: period_end DATE;
565: l_date DATE;
566: l_registered_no hr_organization_information.org_information1%TYPE;
567: l_registered_name hr_organization_units.name%TYPE;
568: l_rep_name per_all_people_f.full_name%TYPE;
569: l_rep_desg per_all_positions.name%TYPE;
570: l_org_name hr_organization_units.name%TYPE;

Line 2185: FROM hr_organization_information

2181: ,p_effective_end_date DATE)
2182: IS
2183: SELECT fnd_number.canonical_to_number(org_information2) mon --Month Number
2184: ,SUM(fnd_number.canonical_to_number(org_information5)) pension --Pension Fund Contributions A/c No.10
2185: FROM hr_organization_information
2186: WHERE organization_id = p_pf_org_id
2187: AND ORG_INFORMATION_CONTEXT = 'PER_IN_PF_CHALLAN_INFO'
2188: AND org_information1=TO_CHAR(p_effective_start_date,'YYYY')||'-'||TO_CHAR(p_effective_end_date,'YYYY')
2189: GROUP BY org_information2

Line 2665: hr_organization_information target

2661: CURSOR c_emplr_class is
2662: SELECT target.org_information3
2663: FROM per_assignments_f assign,
2664: hr_soft_coding_keyflex scl,
2665: hr_organization_information target
2666: WHERE assign.assignment_id = p_assignment_id
2667: AND p_earn_date BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date
2668: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2669: AND scl.segment1 = target.organization_id

Line 2682: l_emplr_class hr_organization_information.org_information3%TYPE;

2678: AND assign.assignment_id = p_assignment_id
2679: AND service.period_of_service_id (+)= assign.period_of_service_id;
2680:
2681: l_disable_proof per_disabilities_f.dis_information1%TYPE;
2682: l_emplr_class hr_organization_information.org_information3%TYPE;
2683: l_hire_date date;
2684: l_ceiling_type varchar2(50);
2685:
2686: --

Line 3263: FROM hr_organization_information

3259: ,SUM(fnd_number.canonical_to_number(org_information6)) dli --DLI Contribution A/c No.21
3260: ,SUM(fnd_number.canonical_to_number(org_information7)) edli --EDLI ADM. Charges A/c No.22
3261: ,SUM(fnd_number.canonical_to_number(org_information8)) admin --Adm. Charges A/c No.2
3262: ,SUM(fnd_number.canonical_to_number(org_information6)+fnd_number.canonical_to_number(org_information7)+fnd_number.canonical_to_number(org_information8)) agg
3263: FROM hr_organization_information
3264: WHERE organization_id=p_pf_org_id
3265: AND ORG_INFORMATION_CONTEXT='PER_IN_PF_CHALLAN_INFO'
3266: AND org_information1=to_char(p_effective_start_date,'YYYY')||'-'||to_char(p_effective_end_date,'YYYY')
3267: AND org_information2=to_number(TO_CHAR(TO_DATE('01-03-2004','DD-MM-YYYY'),'MM'))+decode(i,0,9,-3+i)

Line 4354: ,hr_organization_information hoi

4350: CURSOR csr_exempted_pf_orglist
4351: IS
4352: SELECT hou.organization_id orgid
4353: FROM hr_all_organization_units hou
4354: ,hr_organization_information hoi
4355: WHERE hou.organization_id = hoi.organization_id
4356: AND hoi.org_information_context ='PER_IN_PF_DF'
4357: AND hou.organization_id like nvl(p_pf_org_id,'%')
4358: AND hou.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')

Line 4492: l_reg_name hr_organization_information.org_information1%TYPE;

4488: AND p_effective_end_date BETWEEN glb.effective_start_date and glb.effective_end_date;
4489:
4490:
4491:
4492: l_reg_name hr_organization_information.org_information1%TYPE;
4493: l_rep_name per_all_people_f.full_name%TYPE;
4494: l_org_address pay_action_information.action_information1%TYPE;
4495: --In the Rarest case of location adddress exceeding 240 characters nothing can be done
4496: l_est_code hr_organization_information.org_information1%TYPE;

Line 4496: l_est_code hr_organization_information.org_information1%TYPE;

4492: l_reg_name hr_organization_information.org_information1%TYPE;
4493: l_rep_name per_all_people_f.full_name%TYPE;
4494: l_org_address pay_action_information.action_information1%TYPE;
4495: --In the Rarest case of location adddress exceeding 240 characters nothing can be done
4496: l_est_code hr_organization_information.org_information1%TYPE;
4497:
4498: g_org_XMLTable pay_in_xml_utils.tXMLTable;
4499:
4500: l_employee_name per_all_people_f.full_name%TYPE;

Line 5425: FROM hr_organization_information

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

Line 5448: FROM hr_organization_information

5444: ,TO_NUMBER(org_information9) immediate_employer_covered
5445: ,org_information10 wages_immediate_emplr_covered
5446: ,TO_NUMBER(org_information11) immediate_emplr_not_covered
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:

Line 5481: ,hr_organization_information hoi

5477: IS
5478: SELECT hoi.org_information3 branch_name
5479: ,hoi.org_information4 branch_add
5480: FROM hr_organization_units hou
5481: ,hr_organization_information hoi
5482: WHERE hoi.organization_id = hou.organization_id
5483: AND hoi.org_information_context = 'PER_IN_ESI_BANK_BRANCH_DTLS'
5484: AND hou.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
5485: AND hoi.org_information1 = p_bank_code

Line 5516: l_employer_code hr_organization_information.org_information1%TYPE;

5512: l_bg_id NUMBER;
5513: l_payroll DATE;
5514: l_tag VARCHAR2(1000);
5515: l_payroll_act_id NUMBER;
5516: l_employer_code hr_organization_information.org_information1%TYPE;
5517: l_registered_name hr_organization_units.name%TYPE;
5518: l_reg_address VARCHAR2(240);
5519: l_rep_name per_all_people_f.full_name%TYPE;
5520: l_rep_desg per_all_positions.name%TYPE;