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 PER_ALL_ASSIGNMENTS_F

Line 465: from per_all_assignments_f

461: -- Cursor to get person_id of the assignments selected
462:
463: cursor c_person_id (cp_assign_id number) is
464: select person_id
465: from per_all_assignments_f
466: where assignment_id = cp_assign_id;
467:
468: -- Cursor to get Employee details
469:

Line 477: from per_all_assignments_f

473: where person_id = cp_person_id;
474:
475: cursor c_assignment_no (cp_assign_id number ) is
476: select assignment_number
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;

Line 513: per_all_assignments_f paf

509:
510: cursor c_get_person_id (cp_assign_set_id number) is
511: select distinct paf.person_id
512: from hr_assignment_set_amendments has,
513: per_all_assignments_f paf
514: where has.assignment_set_id = cp_assign_set_id
515: and has.include_or_exclude = 'I'
516: and paf.assignment_id = has.assignment_id
517: and paf.assignment_type = 'E'

Line 527: per_all_assignments_f paf,

523: cp_gre_id number,
524: cp_effective_date date) is
525: select paa.assignment_action_id
526: from pay_assignment_actions paa,
527: per_all_assignments_f paf,
528: pay_payroll_actions ppa,
529: pay_action_classifications pac
530: where paf.person_id = cp_person_id
531: and paa.assignment_id = paf.assignment_id

Line 580: from per_all_assignments_f paf

576: Get the primary assignment for the given person_id */
577:
578: cursor c_get_asg_id (cp_person_id number) is
579: select assignment_id
580: from per_all_assignments_f paf
581: where person_id = cp_person_id
582: and primary_flag = 'Y'
583: and assignment_type = 'E'
584: and paf.effective_start_date <= add_months(p_effective_date, 12) - 1

Line 592: l_assignment_id per_all_assignments_f.assignment_id%type;

588: l_bal_aaid pay_assignment_actions.assignment_action_id%type;
589: ln_non_taxable_earnings number(30);
590: ln_gross_earnings number(30);
591: ln_no_gross_earnings number(30);
592: l_assignment_id per_all_assignments_f.assignment_id%type;
593: l_person_id per_all_assignments_f.person_id%type;
594: l_yepp_payroll_action_id pay_payroll_actions.payroll_action_id%type;
595: lockingactid pay_assignment_actions.assignment_action_id%type;
596: l_prev_person_id per_all_assignments_f.person_id%type;

Line 593: l_person_id per_all_assignments_f.person_id%type;

589: ln_non_taxable_earnings number(30);
590: ln_gross_earnings number(30);
591: ln_no_gross_earnings number(30);
592: l_assignment_id per_all_assignments_f.assignment_id%type;
593: l_person_id per_all_assignments_f.person_id%type;
594: l_yepp_payroll_action_id pay_payroll_actions.payroll_action_id%type;
595: lockingactid pay_assignment_actions.assignment_action_id%type;
596: l_prev_person_id per_all_assignments_f.person_id%type;
597:

Line 596: l_prev_person_id per_all_assignments_f.person_id%type;

592: l_assignment_id per_all_assignments_f.assignment_id%type;
593: l_person_id per_all_assignments_f.person_id%type;
594: l_yepp_payroll_action_id pay_payroll_actions.payroll_action_id%type;
595: lockingactid pay_assignment_actions.assignment_action_id%type;
596: l_prev_person_id per_all_assignments_f.person_id%type;
597:
598: BEGIN
599:
600: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 10);

Line 799: per_all_assignments_f paf

795:
796: cursor c_get_person_id (cp_assign_set_id number) is
797: select distinct paf.person_id
798: from hr_assignment_set_amendments has,
799: per_all_assignments_f paf
800: where has.assignment_set_id = cp_assign_set_id
801: and has.include_or_exclude = 'I'
802: and paf.assignment_id = has.assignment_id
803: and paf.assignment_type = 'E'

Line 822: per_all_assignments_f paf,

818: cp_gre_id number,
819: cp_effective_date date) is
820: select paa.assignment_action_id
821: from pay_assignment_actions paa,
822: per_all_assignments_f paf,
823: per_all_people_f ppf,
824: pay_payroll_actions ppa,
825: pay_action_classifications pac
826: where ppf.person_id = cp_person_id

Line 870: from per_all_assignments_f paf

866: Get the primary assignment for the given person_id */
867:
868: cursor c_get_asg_id (cp_person_id number) is
869: select assignment_id
870: from per_all_assignments_f paf
871: where person_id = cp_person_id
872: and primary_flag = 'Y'
873: and assignment_type = 'E'
874: and paf.effective_start_date <= add_months(p_effective_date, 12) - 1

Line 882: l_assignment_id per_all_assignments_f.assignment_id%type;

878: l_bal_aaid pay_assignment_actions.assignment_action_id%type;
879: ln_non_taxable_earnings number(30);
880: ln_gross_earnings number(30);
881: ln_no_gross_earnings number(30);
882: l_assignment_id per_all_assignments_f.assignment_id%type;
883: l_person_id per_all_assignments_f.person_id%type;
884: l_prev_person_id per_all_assignments_f.person_id%type;
885: l_yepp_payroll_action_id pay_payroll_actions.payroll_action_id%type;
886: lockingactid pay_assignment_actions.assignment_action_id%type;

Line 883: l_person_id per_all_assignments_f.person_id%type;

879: ln_non_taxable_earnings number(30);
880: ln_gross_earnings number(30);
881: ln_no_gross_earnings number(30);
882: l_assignment_id per_all_assignments_f.assignment_id%type;
883: l_person_id per_all_assignments_f.person_id%type;
884: l_prev_person_id per_all_assignments_f.person_id%type;
885: l_yepp_payroll_action_id pay_payroll_actions.payroll_action_id%type;
886: lockingactid pay_assignment_actions.assignment_action_id%type;
887: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

Line 884: l_prev_person_id per_all_assignments_f.person_id%type;

880: ln_gross_earnings number(30);
881: ln_no_gross_earnings number(30);
882: l_assignment_id per_all_assignments_f.assignment_id%type;
883: l_person_id per_all_assignments_f.person_id%type;
884: l_prev_person_id per_all_assignments_f.person_id%type;
885: l_yepp_payroll_action_id pay_payroll_actions.payroll_action_id%type;
886: lockingactid pay_assignment_actions.assignment_action_id%type;
887: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
888:

Line 1060: per_all_assignments_f paf

1056: cp_gre_id number,
1057: cp_assignment_set_id number) is
1058: select distinct has.assignment_id
1059: from hr_assignment_set_amendments has,
1060: per_all_assignments_f paf
1061: where has.assignment_set_id = cp_assignment_set_id
1062: and paf.assignment_id = has.assignment_id
1063: and paf.assignment_type = 'E'
1064: and paf.primary_flag = 'Y'

Line 1085: per_all_assignments_f paf

1081: cp_pre_id number,
1082: cp_assignment_set_id number) is
1083: select distinct has.assignment_id
1084: from hr_assignment_set_amendments has,
1085: per_all_assignments_f paf
1086: where has.assignment_set_id = cp_assignment_set_id
1087: and paf.assignment_id = has.assignment_id
1088: and paf.assignment_type = 'E'
1089: and paf.primary_flag = 'Y'

Line 1104: l_processed_assignment_id per_all_assignments_f.assignment_id%type;

1100: = cp_pre_id
1101: and ppa1.payroll_action_id = paa1.payroll_action_id
1102: and paa1.serial_number = to_char(paf.person_id));
1103:
1104: l_processed_assignment_id per_all_assignments_f.assignment_id%type;
1105:
1106: BEGIN
1107:
1108: if p_report_type in ('T4','T4A') then

Line 1188: per_all_assignments_f paf,

1184: cp_gre_id number,
1185: cp_effective_date date) is
1186: select distinct has.assignment_id
1187: from hr_assignment_set_amendments has,
1188: per_all_assignments_f paf,
1189: pay_assignment_actions paa,
1190: pay_payroll_actions ppa
1191: where has.assignment_set_id = cp_assignment_set_id
1192: and paf.assignment_id = has.assignment_id

Line 1216: l_assignment_id per_all_assignments_f.assignment_id%type;

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;
1215:
1216: l_assignment_id per_all_assignments_f.assignment_id%type;
1217: l_gre pay_assignment_actions.tax_unit_id%type;
1218:
1219: BEGIN
1220:

Line 1355: per_all_assignments_f paf,

1351: cp_gre_id number,
1352: cp_effective_date date) is
1353: select distinct has.assignment_id
1354: from hr_assignment_set_amendments has,
1355: per_all_assignments_f paf,
1356: pay_assignment_actions paa,
1357: pay_payroll_actions ppa
1358: where has.assignment_set_id = cp_assignment_set_id
1359: and paf.assignment_id = has.assignment_id

Line 1379: per_all_assignments_f paf,

1375: cp_pre_id number,
1376: cp_effective_date date) is
1377: select distinct has.assignment_id
1378: from hr_assignment_set_amendments has,
1379: per_all_assignments_f paf,
1380: pay_assignment_actions paa,
1381: pay_payroll_actions ppa
1382: where has.assignment_set_id = cp_assignment_set_id
1383: and paf.assignment_id = has.assignment_id

Line 1404: l_assignment_id per_all_assignments_f.assignment_id%type;

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);
1403:
1404: l_assignment_id per_all_assignments_f.assignment_id%type;
1405: l_count number;
1406: l_header_printed varchar2(1);
1407:
1408: BEGIN

Line 1542: per_all_assignments_f paf,

1538: cp_effective_date date) is
1539: select distinct has.assignment_id,
1540: paa.tax_unit_id
1541: from hr_assignment_set_amendments has,
1542: per_all_assignments_f paf,
1543: pay_assignment_actions paa,
1544: pay_payroll_actions ppa
1545: where has.assignment_set_id = cp_assignment_set_id
1546: and paf.assignment_id = has.assignment_id

Line 1566: per_all_assignments_f paf,

1562: cp_effective_date date) is
1563: select distinct has.assignment_id,
1564: hoi.org_information2
1565: from hr_assignment_set_amendments has,
1566: per_all_assignments_f paf,
1567: pay_assignment_actions paa,
1568: pay_payroll_actions ppa,
1569: hr_organization_information hoi
1570: where has.assignment_set_id = cp_assignment_set_id

Line 1599: l_oth_assignment_id per_all_assignments_f.assignment_id%type;

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;
1600: l_gre_id pay_assignment_actions.tax_unit_id%type;
1601: l_pre_id pay_assignment_actions.tax_unit_id%type;
1602: l_header_printed varchar2(1) := 'N';
1603: