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_SOC_SEC_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 918: FROM hr_organization_units

914: AND organization_id = cp_organization_id ;
915:
916: CURSOR c_org_name ( cp_organization_id IN NUMBER) IS
917: SELECT name
918: FROM hr_organization_units
919: WHERE organization_id = cp_organization_id;
920:
921: CURSOR c_waybill_of_trnsmtr ( cp_organization_id IN NUMBER) IS
922: SELECT org_information5 WayBill_Number

Line 3929: FROM hr_organization_units hou,

3925: FUNCTION get_IDW_calc_method(p_org_id IN NUMBER
3926: ,p_effective_date IN DATE) RETURN VARCHAR2 IS
3927: CURSOR c_get_idw_calc_method IS
3928: SELECT hoi.org_information10
3929: FROM hr_organization_units hou,
3930: hr_organization_information hoi
3931: WHERE hou.organization_id = p_org_id
3932: AND hoi.org_information_context ='MX_SOC_SEC_DETAILS'
3933: AND hou.organization_id = hoi.organization_id

Line 3975: ln_business_group_id hr_organization_units.organization_id%TYPE;

3971:
3972: lv_procedure_name VARCHAR2(200);
3973: lv_end_date VARCHAR2(19);
3974: lv_start_date VARCHAR2(19);
3975: ln_business_group_id hr_organization_units.organization_id%TYPE;
3976: ln_gre_id hr_organization_units.organization_id%TYPE;
3977: ln_pactid NUMBER;
3978:
3979: BEGIN

Line 3976: ln_gre_id hr_organization_units.organization_id%TYPE;

3972: lv_procedure_name VARCHAR2(200);
3973: lv_end_date VARCHAR2(19);
3974: lv_start_date VARCHAR2(19);
3975: ln_business_group_id hr_organization_units.organization_id%TYPE;
3976: ln_gre_id hr_organization_units.organization_id%TYPE;
3977: ln_pactid NUMBER;
3978:
3979: BEGIN
3980: