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_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 241: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;

237: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
238: str varchar2(1000);
239: l_person_id per_people_f.person_id%TYPE;
240: l_assignment_set_id pay_payroll_actions.assignment_set_id%TYPE;
241: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;
242:
243: begin
244: -- hr_utility.trace_on(null,'ROE');
245:

Line 682: from pay_assignment_actions paa,

678: declare
679:
680: cursor cur_aaid is
681: select paa.assignment_action_id
682: from pay_assignment_actions paa,
683: pay_payroll_actions ppa,
684: per_assignments_f paf
685: where paf.person_id = p_person_id
686: and paf.assignment_id = paa.assignment_id

Line 874: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;

870: l_assignment_set_id pay_payroll_actions.assignment_set_id%type;
871: l_effective_date pay_payroll_actions.effective_date%type;
872: l_effective_date1 pay_payroll_actions.effective_date%type;
873: l_business_group_id pay_payroll_actions.business_group_id%type;
874: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;
875:
876: cursor cur_asg_set_person_id is
877: select
878: distinct paf.person_id person_id

Line 918: pay_assignment_actions paa,

914: select
915: distinct paa.tax_unit_id gre_id,
916: 'T4' gre_type
917: from
918: pay_assignment_actions paa,
919: pay_payroll_actions ppa,
920: hr_organization_information hoi
921: where
922: paa.assignment_id = p_assignment_id and

Line 937: pay_assignment_actions paa,

933: select
934: distinct paa.tax_unit_id gre_id,
935: 'T4A' gre_type
936: from
937: pay_assignment_actions paa,
938: pay_payroll_actions ppa,
939: hr_organization_information hoi
940: where
941: paa.assignment_id = p_assignment_id and

Line 954: pay_assignment_actions paa_t4,

950: hoi.org_information5 in ('T4A/RL1','T4A/RL2') and
951: not exists
952: (select 1
953: from
954: pay_assignment_actions paa_t4,
955: pay_payroll_actions ppa_t4,
956: hr_organization_information hoi_t4
957: where
958: paa_t4.assignment_id = p_assignment_id and

Line 971: pay_assignment_actions_s.nextval

967: hoi_t4.org_information5 = 'T4/RL1');
968:
969: cursor cur_asg_action_id is
970: select
971: pay_assignment_actions_s.nextval
972: from
973: dual;
974:
975: cursor cur_prd_end_date(p_payroll_id number,

Line 1081: pay_assignment_actions paa,

1077: select
1078: paa.assignment_action_id locked_action_id
1079: from
1080: pay_payroll_actions ppa,
1081: pay_assignment_actions paa,
1082: ff_archive_items fai1,
1083: ff_archive_items fai2
1084: where
1085: ppa.report_type = 'ROE' and

Line 1373: update pay_assignment_actions

1369: hr_nonrun_asact.insact(l_lockingactid,i.assignment_id,
1370: pactid,chunk,k.gre_id);
1371:
1372: IF multiple_gre THEN
1373: update pay_assignment_actions
1374: set
1375: serial_number = 'Y'
1376: where
1377: assignment_action_id = l_lockingactid;

Line 1554: update pay_assignment_actions

1550: hr_nonrun_asact.insact(l_lockingactid,i.assignment_id,
1551: pactid,chunk,k.gre_id);
1552:
1553: IF multiple_gre THEN
1554: update pay_assignment_actions
1555: set
1556: serial_number = 'Y'
1557: where
1558: assignment_action_id = l_lockingactid;

Line 1654: pay_assignment_actions paa,

1650: select
1651: fai2.value
1652: from
1653: pay_payroll_actions ppa,
1654: pay_assignment_actions paa,
1655: ff_archive_items fai1,
1656: ff_archive_items fai2
1657: where
1658: ppa.report_type = 'ROE' and

Line 1725: pay_assignment_actions paa

1721: legislative_parameters,
1722: NVL(paa.serial_number,'N')
1723: from
1724: pay_payroll_actions ppa,
1725: pay_assignment_actions paa
1726: where
1727: paa.assignment_action_id = p_assactid and
1728: paa.payroll_action_id = ppa.payroll_action_id;
1729:

Line 1741: l_assignment_id pay_assignment_actions.assignment_id%type;

1737: ptp.payroll_id = p_payroll_id and
1738: p_date between
1739: ptp.start_date and ptp.end_date;
1740:
1741: l_assignment_id pay_assignment_actions.assignment_id%type;
1742: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1743: l_effective_date pay_payroll_actions.effective_date%type;
1744: l_business_group_id pay_payroll_actions.business_group_id%type;
1745: total_no_fields number;

Line 1742: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

1738: p_date between
1739: ptp.start_date and ptp.end_date;
1740:
1741: l_assignment_id pay_assignment_actions.assignment_id%type;
1742: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1743: l_effective_date pay_payroll_actions.effective_date%type;
1744: l_business_group_id pay_payroll_actions.business_group_id%type;
1745: total_no_fields number;
1746: l_payroll_id pay_payroll_actions.payroll_id%type;

Line 1748: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;

1744: l_business_group_id pay_payroll_actions.business_group_id%type;
1745: total_no_fields number;
1746: l_payroll_id pay_payroll_actions.payroll_id%type;
1747: l_person_id per_people_f.person_id%TYPE;
1748: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;
1749:
1750:
1751: cursor cur_person_id(p_assignment_action_id number) is
1752: select

Line 1755: pay_assignment_actions paa,

1751: cursor cur_person_id(p_assignment_action_id number) is
1752: select
1753: paf.person_id person_id
1754: from
1755: pay_assignment_actions paa,
1756: per_assignments_f paf
1757: where
1758: paa.assignment_action_id = p_assignment_action_id and
1759: paa.assignment_id = paf.assignment_id and

Line 2027: pay_assignment_actions paa,

2023: cursor cur_final_pay_period_date(p_pay_period_end_date date) is
2024: select min(ptp.start_date) start_date,
2025: max(ptp.end_date) end_date
2026: from pay_payroll_actions ppa,
2027: pay_assignment_actions paa,
2028: per_time_periods ptp,
2029: per_time_period_types tptype
2030: where paa.assignment_id = l_assignment_id
2031: and paa.tax_unit_id = l_tax_unit_id

Line 2045: pay_assignment_actions paa

2041:
2042: cursor cur_last_pay_date is
2043: select max(ppa.date_earned) last_day_paid
2044: from pay_payroll_actions ppa,
2045: pay_assignment_actions paa
2046: where paa.assignment_id = l_assignment_id
2047: and paa.payroll_action_id = ppa.payroll_action_id
2048: and ppa.action_type in ('R','Q')
2049: and paa.action_status = 'C'

Line 2099: l_latest_aaid pay_assignment_actions.assignment_action_id%TYPE

2095: l_roe_issuer pay_payrolls_f.prl_information4%TYPE;
2096: l_roe_correspondence_language per_people_f.full_name%TYPE;
2097: l_pay_period_end_date date;
2098: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
2099: l_latest_aaid pay_assignment_actions.assignment_action_id%TYPE
2100: := 0;
2101: l_latest_aaid_after_term pay_assignment_actions.assignment_action_id%TYPE
2102: := 0;
2103: l_period_end_date_after_term date;

Line 2101: l_latest_aaid_after_term pay_assignment_actions.assignment_action_id%TYPE

2097: l_pay_period_end_date date;
2098: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
2099: l_latest_aaid pay_assignment_actions.assignment_action_id%TYPE
2100: := 0;
2101: l_latest_aaid_after_term pay_assignment_actions.assignment_action_id%TYPE
2102: := 0;
2103: l_period_end_date_after_term date;
2104: l_period_start_date_after_term date;
2105:

Line 2112: pay_assignment_actions paa,

2108: p_tax_unit_id number) is
2109: select
2110: max(paa.assignment_action_id)
2111: from
2112: pay_assignment_actions paa,
2113: pay_payroll_actions ppa,
2114: per_assignments_f paf
2115: where
2116: paa.assignment_id = l_assignment_id and

Line 2165: l_serial_number pay_assignment_actions.serial_number%TYPE;

2161: l_tax_unit_id tax_unit_id
2162: from
2163: dual;
2164:
2165: l_serial_number pay_assignment_actions.serial_number%TYPE;
2166:
2167: begin
2168:
2169: hr_utility.trace('Archive data');