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_CA_YEPP_ADD_ACTIONS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 371: hr_all_organization_units hou,

367: where exists
368: (select 'X'
369: from hr_organization_information mag,
370: hr_organization_information gre,
371: hr_all_organization_units hou,
372: pay_payroll_actions ppa
373: where hou.business_group_id = cp_business_group_id
374: and hou.organization_id = gre.organization_id
375: and gre.org_information_context = 'Canada Employer Identification'

Line 394: hr_all_organization_units hou,

390: where exists
391: (select 'X'
392: from hr_organization_information mag,
393: hr_organization_information gre,
394: hr_all_organization_units hou,
395: pay_payroll_actions ppa
396: where hou.business_group_id = cp_business_group_id
397: and hou.organization_id = gre.organization_id
398: and gre.org_information_context = 'Canada Employer Identification'

Line 416: hr_all_organization_units hou,

412: select 1 from dual
413: where exists
414: (select 'X'
415: from hr_organization_information pre,
416: hr_all_organization_units hou,
417: pay_payroll_actions ppa
418: where hou.business_group_id = cp_business_group_id
419: and hou.organization_id = pre.organization_id
420: and pre.org_information4 = 'P01'

Line 438: hr_all_organization_units hou,

434: select 1 from dual
435: where exists
436: (select 'X'
437: from hr_organization_information pre,
438: hr_all_organization_units hou,
439: pay_payroll_actions ppa
440: where hou.business_group_id = cp_business_group_id
441: and hou.organization_id = pre.organization_id
442: and pre.org_information4 = 'P02'

Line 457: from hr_all_organization_units_tl

453: -- Cursor to get the GRE or PRE Name
454:
455: cursor c_name (cp_org_id number) is
456: select name
457: from hr_all_organization_units_tl
458: where organization_id = cp_org_id
459: and language = userenv('LANG');
460:
461: -- Cursor to get person_id of the assignments selected

Line 481: lv_gre_name hr_all_organization_units_tl.name%type;

477: from per_all_assignments_f
478: where assignment_id = cp_assign_id;
479:
480: lv_person_id per_all_people_f.person_id%type;
481: lv_gre_name hr_all_organization_units_tl.name%type;
482: lv_pre_name hr_all_organization_units_tl.name%type;
483: lv_emp_name per_all_people_f.full_name%type;
484: lv_emp_no per_all_people_f.employee_number%type;
485: lv_emp_sin per_all_people_f.national_identifier%type;

Line 482: lv_pre_name hr_all_organization_units_tl.name%type;

478: where assignment_id = cp_assign_id;
479:
480: lv_person_id per_all_people_f.person_id%type;
481: lv_gre_name hr_all_organization_units_tl.name%type;
482: lv_pre_name hr_all_organization_units_tl.name%type;
483: lv_emp_name per_all_people_f.full_name%type;
484: lv_emp_no per_all_people_f.employee_number%type;
485: lv_emp_sin per_all_people_f.national_identifier%type;
486: lv_data_row varchar2(4000);

Line 809: hr_all_organization_units hou

805:
806: cursor c_all_gres is
807: select hoi.organization_id
808: from hr_organization_information hoi,
809: hr_all_organization_units hou
810: where hoi.org_information_context = 'Canada Employer Identification'
811: and hoi.org_information2 = to_char(p_pre_id)
812: and hou.business_group_id = p_bus_grp
813: and hou.organization_id = hoi.organization_id;

Line 1210: hr_all_organization_units hou

1206:
1207: cursor c_all_gres is
1208: select hoi.organization_id
1209: from hr_organization_information hoi,
1210: hr_all_organization_units hou
1211: where hoi.org_information_context = 'Canada Employer Identification'
1212: and hoi.org_information2 = to_char(p_pre_id)
1213: and hou.business_group_id = p_bus_grp
1214: and hou.organization_id = hoi.organization_id;

Line 1398: hr_all_organization_units hou

1394: and paf.assignment_type = 'E'
1395: and paf.primary_flag <> 'Y'
1396: and paa.tax_unit_id in (select hoi.organization_id
1397: from hr_organization_information hoi,
1398: hr_all_organization_units hou
1399: where hoi.org_information_context = 'Canada Employer Identification'
1400: and hoi.org_information2 = to_char(cp_pre_id)
1401: and hou.business_group_id = p_bus_grp
1402: and hou.organization_id = hoi.organization_id);

Line 1587: hr_all_organization_units hou1

1583: and paa.tax_unit_id = hoi.organization_id
1584: and hoi.org_information_context = 'Canada Employer Identification'
1585: and paa.tax_unit_id not in (select hoi1.organization_id
1586: from hr_organization_information hoi1,
1587: hr_all_organization_units hou1
1588: where hoi1.org_information_context = 'Canada Employer Identification'
1589: and hoi1.org_information2 = to_char(cp_pre_id)
1590: and hou1.business_group_id = p_bus_grp
1591: and hou1.organization_id = hoi1.organization_id);

Line 1595: from hr_all_organization_units_tl

1591: and hou1.organization_id = hoi1.organization_id);
1592:
1593: cursor c_get_name(cp_org_id number) is
1594: select name
1595: from hr_all_organization_units_tl
1596: where organization_id = cp_org_id
1597: and language = userenv('LANG');
1598:
1599: l_oth_assignment_id per_all_assignments_f.assignment_id%type;