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 PAY_ASSIGNMENT_ACTIONS

Line 526: from pay_assignment_actions paa,

522: cursor c_get_latest_asg (cp_person_id number,
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

Line 551: pay_assignment_actions paa1

547: and paa.run_type_id is not null
548: and paa.source_action_id is null))
549: and not exists (select 1
550: from pay_payroll_actions ppa1,
551: pay_assignment_actions paa1
552: where ppa1.report_type = p_report_type
553: and ppa1.business_group_id+0 = p_bus_grp
554: and ppa1.effective_date = add_months(cp_effective_date, 12) - 1
555: and to_number(get_parameter('TRANSFER_GRE',

Line 588: l_bal_aaid pay_assignment_actions.assignment_action_id%type;

584: and paf.effective_start_date <= add_months(p_effective_date, 12) - 1
585: and paf.effective_end_date >= p_effective_date
586: order by assignment_id desc;
587:
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;

Line 595: lockingactid pay_assignment_actions.assignment_action_id%type;

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:
598: BEGIN
599:

Line 696: select pay_assignment_actions_s.nextval

692: (ln_no_gross_earnings <> 0)) then
693:
694: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 100);
695:
696: select pay_assignment_actions_s.nextval
697: into lockingactid
698: from dual;
699:
700: hr_utility.trace('creating asg action');

Line 711: update pay_assignment_actions aa

707: status => 'M');
708:
709: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 110);
710:
711: update pay_assignment_actions aa
712: set aa.serial_number = to_char(l_person_id)
713: where aa.assignment_action_id = lockingactid;
714:
715: l_yepp_elgble_asg_table(l_assignment_id).c_assignment_id := l_assignment_id;

Line 743: select pay_assignment_actions_s.nextval

739: (ln_no_gross_earnings <> 0)) then
740:
741: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 130);
742:
743: select pay_assignment_actions_s.nextval
744: into lockingactid
745: from dual;
746:
747: hr_utility.trace('creating asg action');

Line 758: update pay_assignment_actions aa

754: status => 'M');
755:
756: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 140);
757:
758: update pay_assignment_actions aa
759: set aa.serial_number = to_char(l_person_id)
760: where aa.assignment_action_id = lockingactid;
761:
762: l_yepp_elgble_asg_table(l_assignment_id).c_assignment_id := l_assignment_id;

Line 821: from pay_assignment_actions paa,

817: cursor c_get_latest_asg (cp_person_id number,
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

Line 842: pay_assignment_actions paa1

838: and ppa.action_type = pac.action_type
839: and pac.classification_name = 'SEQUENCED'
840: and not exists (select 1
841: from pay_payroll_actions ppa1,
842: pay_assignment_actions paa1
843: where ppa1.report_type = p_report_type
844: and ppa1.business_group_id+0 = p_bus_grp
845: and ppa1.effective_date = add_months(cp_effective_date, 12) - 1
846: and to_number(get_parameter('PRE_ORGANIZATION_ID',

Line 878: l_bal_aaid pay_assignment_actions.assignment_action_id%type;

874: and paf.effective_start_date <= add_months(p_effective_date, 12) - 1
875: and paf.effective_end_date >= p_effective_date
876: order by assignment_id desc;
877:
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;

Line 886: lockingactid pay_assignment_actions.assignment_action_id%type;

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:
889: BEGIN
890:

Line 887: l_tax_unit_id pay_assignment_actions.tax_unit_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:
889: BEGIN
890:
891: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_prov', 10);

Line 1003: select pay_assignment_actions_s.nextval

999: ) then
1000:
1001: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_prov', 100);
1002:
1003: select pay_assignment_actions_s.nextval
1004: into lockingactid
1005: from dual;
1006:
1007: hr_utility.trace('creating asg action');

Line 1018: update pay_assignment_actions aa

1014: status => 'M');
1015:
1016: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_prov', 110);
1017:
1018: update pay_assignment_actions aa
1019: set aa.serial_number = to_char(l_person_id)
1020: where aa.assignment_action_id = lockingactid;
1021:
1022:

Line 1070: pay_assignment_actions paa1

1066: and paf.effective_start_date <= add_months(cp_effective_date, 12) - 1
1067: and paf.effective_end_date >= cp_effective_date
1068: and exists (select 1
1069: from pay_payroll_actions ppa1,
1070: pay_assignment_actions paa1
1071: where ppa1.report_type = p_report_type
1072: and ppa1.business_group_id+0 = p_bus_grp
1073: and ppa1.effective_date = add_months(cp_effective_date, 12) - 1
1074: and to_number(get_parameter('TRANSFER_GRE', ppa1.legislative_parameters))

Line 1095: pay_assignment_actions paa1

1091: and paf.effective_start_date <= add_months(cp_effective_date, 12) - 1
1092: and paf.effective_end_date >= cp_effective_date
1093: and exists (select 1
1094: from pay_payroll_actions ppa1,
1095: pay_assignment_actions paa1
1096: where ppa1.report_type = p_report_type
1097: and ppa1.business_group_id+0 = p_bus_grp
1098: and ppa1.effective_date = add_months(cp_effective_date, 12) - 1
1099: and to_number(get_parameter('PRE_ORGANIZATION_ID', ppa1.legislative_parameters))

Line 1189: pay_assignment_actions paa,

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
1193: and nvl(has.include_or_exclude,'I') = 'I'

Line 1217: l_gre pay_assignment_actions.tax_unit_id%type;

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:
1221: if p_report_type in ('T4','T4A') then

Line 1356: pay_assignment_actions paa,

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
1360: and nvl(has.include_or_exclude,'I') = 'I'

Line 1380: pay_assignment_actions paa,

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
1384: and nvl(has.include_or_exclude,'I') = 'I'

Line 1543: pay_assignment_actions paa,

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
1547: and nvl(has.include_or_exclude,'I') = 'I'

Line 1567: pay_assignment_actions paa,

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
1571: and paf.assignment_id = has.assignment_id

Line 1600: l_gre_id pay_assignment_actions.tax_unit_id%type;

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:
1604: BEGIN

Line 1601: l_pre_id pay_assignment_actions.tax_unit_id%type;

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:
1604: BEGIN
1605: