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_MX_PAYROLL_ARCH dependencies on HR_ORGANIZATION_INFORMATION

Line 3238: FROM hr_organization_information

3234: CURSOR c_get_legal_er_details(cp_legal_er_id NUMBER)
3235: IS
3236: SELECT org_information1 "Employer Name",
3237: org_information2 "Employer RFC ID"
3238: FROM hr_organization_information
3239: WHERE organization_id = cp_legal_er_id
3240: AND org_information_context = 'MX_TAX_REGISTRATION';
3241:
3242: CURSOR c_get_er_ss_id

Line 3245: FROM hr_organization_information

3241:
3242: CURSOR c_get_er_ss_id
3243: IS
3244: SELECT org_information1 "Employer Social Security ID"
3245: FROM hr_organization_information
3246: WHERE organization_id = p_tax_unit_id
3247: AND org_information_context = 'MX_SOC_SEC_DETAILS';
3248:
3249: ln_index NUMBER;

Line 3254: lv_er_rfc_id hr_organization_information.org_information1%TYPE;

3250: lv_ee_rfc_id per_all_people_f.per_information2%TYPE;
3251: lv_ee_ss_id per_all_people_f.per_information3%TYPE;
3252: ln_business_group_id NUMBER;
3253: ln_legal_employer_id NUMBER;
3254: lv_er_rfc_id hr_organization_information.org_information1%TYPE;
3255: lv_er_ss_id hr_organization_information.org_information1%TYPE;
3256: lv_legal_employer_name hr_all_organization_units.name%TYPE;
3257: lv_gre_name hr_all_organization_units.name%TYPE;
3258: ld_date_start DATE;

Line 3255: lv_er_ss_id hr_organization_information.org_information1%TYPE;

3251: lv_ee_ss_id per_all_people_f.per_information3%TYPE;
3252: ln_business_group_id NUMBER;
3253: ln_legal_employer_id NUMBER;
3254: lv_er_rfc_id hr_organization_information.org_information1%TYPE;
3255: lv_er_ss_id hr_organization_information.org_information1%TYPE;
3256: lv_legal_employer_name hr_all_organization_units.name%TYPE;
3257: lv_gre_name hr_all_organization_units.name%TYPE;
3258: ld_date_start DATE;
3259:

Line 3909: FROM hr_organization_information hoi_LE,

3905: SELECT nvl(hoi_LE.org_information1, -- Bug 4155512
3906: hr_general.decode_organization(p_legal_er_id)) "Employer Name",
3907: hoi_LE.org_information2 "Employer RFC ID",
3908: hoi_GRE.org_information1 "Employer Social Security ID"
3909: FROM hr_organization_information hoi_LE,
3910: hr_organization_information hoi_GRE
3911: WHERE hoi_LE.organization_id = p_legal_er_id
3912: AND hoi_LE.org_information_context = 'MX_TAX_REGISTRATION'
3913: AND hoi_GRE.organization_id(+) = hoi_LE.organization_id

Line 3910: hr_organization_information hoi_GRE

3906: hr_general.decode_organization(p_legal_er_id)) "Employer Name",
3907: hoi_LE.org_information2 "Employer RFC ID",
3908: hoi_GRE.org_information1 "Employer Social Security ID"
3909: FROM hr_organization_information hoi_LE,
3910: hr_organization_information hoi_GRE
3911: WHERE hoi_LE.organization_id = p_legal_er_id
3912: AND hoi_LE.org_information_context = 'MX_TAX_REGISTRATION'
3913: AND hoi_GRE.organization_id(+) = hoi_LE.organization_id
3914: AND hoi_GRE.org_information_context(+) = 'MX_SOC_SEC_DETAILS';

Line 3916: lv_legal_employer_name hr_organization_information.org_information1%TYPE;

3912: AND hoi_LE.org_information_context = 'MX_TAX_REGISTRATION'
3913: AND hoi_GRE.organization_id(+) = hoi_LE.organization_id
3914: AND hoi_GRE.org_information_context(+) = 'MX_SOC_SEC_DETAILS';
3915:
3916: lv_legal_employer_name hr_organization_information.org_information1%TYPE;
3917: lv_er_rfc_id hr_organization_information.org_information2%TYPE;
3918: lv_er_ss_id hr_organization_information.org_information1%TYPE;
3919: ln_index NUMBER;
3920:

Line 3917: lv_er_rfc_id hr_organization_information.org_information2%TYPE;

3913: AND hoi_GRE.organization_id(+) = hoi_LE.organization_id
3914: AND hoi_GRE.org_information_context(+) = 'MX_SOC_SEC_DETAILS';
3915:
3916: lv_legal_employer_name hr_organization_information.org_information1%TYPE;
3917: lv_er_rfc_id hr_organization_information.org_information2%TYPE;
3918: lv_er_ss_id hr_organization_information.org_information1%TYPE;
3919: ln_index NUMBER;
3920:
3921: BEGIN

Line 3918: lv_er_ss_id hr_organization_information.org_information1%TYPE;

3914: AND hoi_GRE.org_information_context(+) = 'MX_SOC_SEC_DETAILS';
3915:
3916: lv_legal_employer_name hr_organization_information.org_information1%TYPE;
3917: lv_er_rfc_id hr_organization_information.org_information2%TYPE;
3918: lv_er_ss_id hr_organization_information.org_information1%TYPE;
3919: ln_index NUMBER;
3920:
3921: BEGIN
3922: OPEN c_get_legal_er_details;

Line 3954: FROM hr_organization_information hoi

3950: --
3951: CURSOR c_get_gre_details
3952: IS
3953: SELECT org_information1 "Employer Social Security ID"
3954: FROM hr_organization_information hoi
3955: WHERE organization_id = p_gre_id
3956: AND org_information_context = 'MX_SOC_SEC_DETAILS'
3957: AND organization_id NOT IN
3958: (SELECT organization_id

Line 3959: FROM hr_organization_information

3955: WHERE organization_id = p_gre_id
3956: AND org_information_context = 'MX_SOC_SEC_DETAILS'
3957: AND organization_id NOT IN
3958: (SELECT organization_id
3959: FROM hr_organization_information
3960: WHERE org_information_context
3961: = 'MX_TAX_REGISTRATION'
3962: );
3963:

Line 3964: lv_er_ss_id hr_organization_information.org_information1%TYPE;

3960: WHERE org_information_context
3961: = 'MX_TAX_REGISTRATION'
3962: );
3963:
3964: lv_er_ss_id hr_organization_information.org_information1%TYPE;
3965: ln_index NUMBER;
3966:
3967: BEGIN
3968: OPEN c_get_gre_details;

Line 3995: FROM hr_organization_information hri

3991: SELECT hri.org_information1,
3992: hri.org_information2, hri.org_information3,
3993: hri.org_information4, hri.org_information5,
3994: hri.org_information6, hri.org_information7
3995: FROM hr_organization_information hri
3996: WHERE hri.organization_id = cp_organization_id
3997: AND hri.org_information_context = cp_org_information_context
3998: AND hri.org_information1 = 'MESG';
3999:

Line 4000: lv_org_information1 hr_organization_information.org_information1%TYPE;

3996: WHERE hri.organization_id = cp_organization_id
3997: AND hri.org_information_context = cp_org_information_context
3998: AND hri.org_information1 = 'MESG';
3999:
4000: lv_org_information1 hr_organization_information.org_information1%TYPE;
4001: lv_org_information2 hr_organization_information.org_information2%TYPE;
4002: lv_org_information3 hr_organization_information.org_information3%TYPE;
4003: lv_org_information4 hr_organization_information.org_information4%TYPE;
4004: lv_org_information5 hr_organization_information.org_information5%TYPE;

Line 4001: lv_org_information2 hr_organization_information.org_information2%TYPE;

3997: AND hri.org_information_context = cp_org_information_context
3998: AND hri.org_information1 = 'MESG';
3999:
4000: lv_org_information1 hr_organization_information.org_information1%TYPE;
4001: lv_org_information2 hr_organization_information.org_information2%TYPE;
4002: lv_org_information3 hr_organization_information.org_information3%TYPE;
4003: lv_org_information4 hr_organization_information.org_information4%TYPE;
4004: lv_org_information5 hr_organization_information.org_information5%TYPE;
4005: lv_org_information6 hr_organization_information.org_information6%TYPE;

Line 4002: lv_org_information3 hr_organization_information.org_information3%TYPE;

3998: AND hri.org_information1 = 'MESG';
3999:
4000: lv_org_information1 hr_organization_information.org_information1%TYPE;
4001: lv_org_information2 hr_organization_information.org_information2%TYPE;
4002: lv_org_information3 hr_organization_information.org_information3%TYPE;
4003: lv_org_information4 hr_organization_information.org_information4%TYPE;
4004: lv_org_information5 hr_organization_information.org_information5%TYPE;
4005: lv_org_information6 hr_organization_information.org_information6%TYPE;
4006: lv_org_information7 hr_organization_information.org_information7%TYPE;

Line 4003: lv_org_information4 hr_organization_information.org_information4%TYPE;

3999:
4000: lv_org_information1 hr_organization_information.org_information1%TYPE;
4001: lv_org_information2 hr_organization_information.org_information2%TYPE;
4002: lv_org_information3 hr_organization_information.org_information3%TYPE;
4003: lv_org_information4 hr_organization_information.org_information4%TYPE;
4004: lv_org_information5 hr_organization_information.org_information5%TYPE;
4005: lv_org_information6 hr_organization_information.org_information6%TYPE;
4006: lv_org_information7 hr_organization_information.org_information7%TYPE;
4007:

Line 4004: lv_org_information5 hr_organization_information.org_information5%TYPE;

4000: lv_org_information1 hr_organization_information.org_information1%TYPE;
4001: lv_org_information2 hr_organization_information.org_information2%TYPE;
4002: lv_org_information3 hr_organization_information.org_information3%TYPE;
4003: lv_org_information4 hr_organization_information.org_information4%TYPE;
4004: lv_org_information5 hr_organization_information.org_information5%TYPE;
4005: lv_org_information6 hr_organization_information.org_information6%TYPE;
4006: lv_org_information7 hr_organization_information.org_information7%TYPE;
4007:
4008: ln_index NUMBER;

Line 4005: lv_org_information6 hr_organization_information.org_information6%TYPE;

4001: lv_org_information2 hr_organization_information.org_information2%TYPE;
4002: lv_org_information3 hr_organization_information.org_information3%TYPE;
4003: lv_org_information4 hr_organization_information.org_information4%TYPE;
4004: lv_org_information5 hr_organization_information.org_information5%TYPE;
4005: lv_org_information6 hr_organization_information.org_information6%TYPE;
4006: lv_org_information7 hr_organization_information.org_information7%TYPE;
4007:
4008: ln_index NUMBER;
4009: lv_procedure_name VARCHAR2(100);

Line 4006: lv_org_information7 hr_organization_information.org_information7%TYPE;

4002: lv_org_information3 hr_organization_information.org_information3%TYPE;
4003: lv_org_information4 hr_organization_information.org_information4%TYPE;
4004: lv_org_information5 hr_organization_information.org_information5%TYPE;
4005: lv_org_information6 hr_organization_information.org_information6%TYPE;
4006: lv_org_information7 hr_organization_information.org_information7%TYPE;
4007:
4008: ln_index NUMBER;
4009: lv_procedure_name VARCHAR2(100);
4010:

Line 4752: FROM hr_organization_information

4748: WHERE paa.assignment_action_id = cp_assignment_action;
4749:
4750: CURSOR c_legislation (cp_business_group IN NUMBER) IS
4751: SELECT org_information9
4752: FROM hr_organization_information
4753: WHERE org_information_context = 'Business Group Information'
4754: AND organization_id = cp_business_group;
4755:
4756: CURSOR c_assignment_run (cp_prepayment_action_id IN NUMBER) IS