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_UNITS

Line 413: ,hr_organization_units hou

409: IS
410: SELECT DISTINCT source_id org_id
411: ,action_information9 org_name
412: FROM pay_action_information
413: ,hr_organization_units hou
414: WHERE action_information_category = 'IN_PT_ASG'
415: AND action_context_type = 'AAP'
416: AND source_id = NVL(p_pt_org_id, source_id)
417: AND jurisdiction_code = 'MH'

Line 567: l_registered_name hr_organization_units.name%TYPE;

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;
571: l_message VARCHAR2(255);

Line 570: l_org_name hr_organization_units.name%TYPE;

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;
571: l_message VARCHAR2(255);
572: l_procedure VARCHAR2(100);
573:
574: l_slab_change09 DATE := to_date('01-07-2009','DD-MM-YYYY');

Line 2084: ,hr_organization_units hou

2080: ,paa_pay.action_information8 --PF Org Name
2081: FROM pay_action_information paa_asg
2082: ,pay_action_information paa_pay
2083: ,pay_assignment_actions paa
2084: ,hr_organization_units hou
2085: WHERE paa_asg.action_information_category = 'IN_PF_ASG'
2086: AND paa_pay.action_information_category = 'IN_PF_PAY'
2087: AND paa_asg.ACTION_CONTEXT_TYPE = 'AAP'
2088: AND paa_pay.ACTION_CONTEXT_TYPE = 'PA'

Line 3141: ,hr_organization_units hou

3137: ,paa_pay.action_information8 --PF Org Name
3138: FROM pay_action_information paa_asg
3139: ,pay_action_information paa_pay
3140: ,pay_assignment_actions paa
3141: ,hr_organization_units hou
3142: WHERE paa_asg.action_information_category='IN_PF_ASG'
3143: AND paa_pay.action_information_category='IN_PF_PAY'
3144: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'
3145: AND paa_pay.ACTION_CONTEXT_TYPE='PA'

Line 3803: ,hr_organization_units hou

3799: ,substr(paa_asg.action_information3 ,instr(paa_asg.action_information3,'/',-1)+1 ) pf_acc
3800: FROM pay_action_information paa_asg
3801: ,pay_action_information paa_pay
3802: ,pay_assignment_actions paa
3803: ,hr_organization_units hou
3804: WHERE paa_asg.action_information_category='IN_PF_ASG'
3805: AND paa_pay.action_information_category='IN_PF_PAY'
3806: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'
3807: AND paa_pay.ACTION_CONTEXT_TYPE='PA'

Line 4011: ,hr_organization_units hou

4007: ,substr(paa_asg.action_information3 ,instr(paa_asg.action_information3,'/',-1)+1 ) pf_acc
4008: FROM pay_action_information paa_asg
4009: ,pay_action_information paa_pay
4010: ,pay_assignment_actions paa
4011: ,hr_organization_units hou
4012: WHERE paa_asg.action_information_category='IN_PF_ASG'
4013: AND paa_pay.action_information_category='IN_PF_PAY'
4014: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'
4015: AND paa_pay.ACTION_CONTEXT_TYPE='PA'

Line 4042: ,hr_organization_units hou

4038: ,substr(paa_asg.action_information3 ,instr(paa_asg.action_information3,'/',-1)+1 ) pf_acc
4039: FROM pay_action_information paa_asg
4040: ,pay_action_information paa_pay
4041: ,pay_assignment_actions paa
4042: ,hr_organization_units hou
4043: WHERE paa_asg.action_information_category='IN_PF_ASG'
4044: AND paa_pay.action_information_category='IN_PF_PAY'
4045: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'
4046: AND paa_pay.ACTION_CONTEXT_TYPE='PA'

Line 5257: ,hr_organization_units hou

5253: IS
5254: SELECT DISTINCT action_information2 org_id
5255: ,action_information8 org_name
5256: FROM pay_action_information
5257: ,hr_organization_units hou
5258: WHERE action_information_category='IN_ESI_PAY'
5259: AND action_context_type='PA'
5260: AND action_information1=p_contribution_period
5261: AND action_information2 LIKE nvl(p_esi_org_id,'%')

Line 5394: FROM hr_organization_units hoi

5390: ) + 1 days
5391: FROM per_periods_of_service pps
5392: WHERE pps.period_of_service_id IN
5393: (SELECT asg.period_of_service_id
5394: FROM hr_organization_units hoi
5395: ,hr_soft_coding_keyflex scf
5396: ,per_all_assignments_f asg
5397: WHERE asg.person_id = p_person_id
5398: AND asg.soft_coding_keyflex_id = scf.soft_coding_keyflex_id

Line 5480: FROM hr_organization_units hou

5476: ,p_branch_code VARCHAR2 )
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')

Line 5517: l_registered_name hr_organization_units.name%TYPE;

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;
5521: l_rep_addr VARCHAR2(240);

Line 5522: l_org_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;
5521: l_rep_addr VARCHAR2(240);
5522: l_org_name hr_organization_units.name%TYPE;
5523: l_person_id NUMBER;
5524: l_insurance_no per_all_people_f.per_information9%TYPE;
5525: l_full_name per_all_people_f.full_name%TYPE;
5526: l_payroll_mon NUMBER;