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 550: l_registered_name hr_organization_units.name%TYPE;

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

Line 553: l_org_name hr_organization_units.name%TYPE;

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;
554: l_message VARCHAR2(255);
555: l_procedure VARCHAR2(100);
556:
557:

Line 1503: ,hr_organization_units hou

1499: ,paa_pay.action_information8 --PF Org Name
1500: FROM pay_action_information paa_asg
1501: ,pay_action_information paa_pay
1502: ,pay_assignment_actions paa
1503: ,hr_organization_units hou
1504: WHERE paa_asg.action_information_category = 'IN_PF_ASG'
1505: AND paa_pay.action_information_category = 'IN_PF_PAY'
1506: AND paa_asg.ACTION_CONTEXT_TYPE = 'AAP'
1507: AND paa_pay.ACTION_CONTEXT_TYPE = 'PA'

Line 2553: ,hr_organization_units hou

2549: ,paa_pay.action_information8 --PF Org Name
2550: FROM pay_action_information paa_asg
2551: ,pay_action_information paa_pay
2552: ,pay_assignment_actions paa
2553: ,hr_organization_units hou
2554: WHERE paa_asg.action_information_category='IN_PF_ASG'
2555: AND paa_pay.action_information_category='IN_PF_PAY'
2556: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'
2557: AND paa_pay.ACTION_CONTEXT_TYPE='PA'

Line 3162: ,hr_organization_units hou

3158: ,paa_asg.action_information2 pf_org_id --PF Org ID
3159: FROM pay_action_information paa_asg
3160: ,pay_action_information paa_pay
3161: ,pay_assignment_actions paa
3162: ,hr_organization_units hou
3163: WHERE paa_asg.action_information_category='IN_PF_ASG'
3164: AND paa_pay.action_information_category='IN_PF_PAY'
3165: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'
3166: AND paa_pay.ACTION_CONTEXT_TYPE='PA'

Line 4538: ,hr_organization_units hou

4534: IS
4535: SELECT DISTINCT action_information2 org_id
4536: ,action_information8 org_name
4537: FROM pay_action_information
4538: ,hr_organization_units hou
4539: WHERE action_information_category='IN_ESI_PAY'
4540: AND action_context_type='PA'
4541: AND action_information1=p_contribution_period
4542: AND action_information2 LIKE nvl(p_esi_org_id,'%')

Line 4675: FROM hr_organization_units hoi

4671: ) + 1 days
4672: FROM per_periods_of_service pps
4673: WHERE pps.period_of_service_id IN
4674: (SELECT asg.period_of_service_id
4675: FROM hr_organization_units hoi
4676: ,hr_soft_coding_keyflex scf
4677: ,per_all_assignments_f asg
4678: WHERE asg.person_id = p_person_id
4679: AND asg.soft_coding_keyflex_id = scf.soft_coding_keyflex_id

Line 4761: FROM hr_organization_units hou

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

Line 4798: l_registered_name hr_organization_units.name%TYPE;

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

Line 4803: l_org_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;
4802: l_rep_addr VARCHAR2(240);
4803: l_org_name hr_organization_units.name%TYPE;
4804: l_person_id NUMBER;
4805: l_insurance_no per_all_people_f.per_information9%TYPE;
4806: l_full_name per_all_people_f.full_name%TYPE;
4807: l_payroll_mon NUMBER;