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 245: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;

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

Line 686: from pay_assignment_actions paa,

682: declare
683:
684: cursor cur_aaid is
685: select paa.assignment_action_id
686: from pay_assignment_actions paa,
687: pay_payroll_actions ppa,
688: per_assignments_f paf
689: where paf.person_id = p_person_id
690: and paf.assignment_id = paa.assignment_id

Line 878: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;

874: l_assignment_set_id pay_payroll_actions.assignment_set_id%type;
875: l_effective_date pay_payroll_actions.effective_date%type;
876: l_effective_date1 pay_payroll_actions.effective_date%type;
877: l_business_group_id pay_payroll_actions.business_group_id%type;
878: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;
879:
880: cursor cur_asg_set_person_id is
881: select
882: distinct paf.person_id person_id

Line 922: pay_assignment_actions paa,

918: select
919: distinct paa.tax_unit_id gre_id,
920: 'T4' gre_type
921: from
922: pay_assignment_actions paa,
923: pay_payroll_actions ppa,
924: hr_organization_information hoi
925: where
926: paa.assignment_id = p_assignment_id and

Line 941: pay_assignment_actions paa,

937: select
938: distinct paa.tax_unit_id gre_id,
939: 'T4A' gre_type
940: from
941: pay_assignment_actions paa,
942: pay_payroll_actions ppa,
943: hr_organization_information hoi
944: where
945: paa.assignment_id = p_assignment_id and

Line 958: pay_assignment_actions paa_t4,

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

Line 975: pay_assignment_actions_s.nextval

971: hoi_t4.org_information5 = 'T4/RL1');
972:
973: cursor cur_asg_action_id is
974: select
975: pay_assignment_actions_s.nextval
976: from
977: dual;
978:
979: cursor cur_prd_end_date(p_payroll_id number,

Line 1085: pay_assignment_actions paa,

1081: select
1082: paa.assignment_action_id locked_action_id
1083: from
1084: pay_payroll_actions ppa,
1085: pay_assignment_actions paa,
1086: ff_archive_items fai1,
1087: ff_archive_items fai2
1088: where
1089: ppa.report_type = 'ROE' and

Line 1377: update pay_assignment_actions

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

Line 1558: update pay_assignment_actions

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

Line 1658: pay_assignment_actions paa,

1654: select
1655: fai2.value
1656: from
1657: pay_payroll_actions ppa,
1658: pay_assignment_actions paa,
1659: ff_archive_items fai1,
1660: ff_archive_items fai2
1661: where
1662: ppa.report_type = 'ROE' and

Line 1729: pay_assignment_actions paa

1725: legislative_parameters,
1726: NVL(paa.serial_number,'N')
1727: from
1728: pay_payroll_actions ppa,
1729: pay_assignment_actions paa
1730: where
1731: paa.assignment_action_id = p_assactid and
1732: paa.payroll_action_id = ppa.payroll_action_id;
1733:

Line 1745: l_assignment_id pay_assignment_actions.assignment_id%type;

1741: ptp.payroll_id = p_payroll_id and
1742: p_date between
1743: ptp.start_date and ptp.end_date;
1744:
1745: l_assignment_id pay_assignment_actions.assignment_id%type;
1746: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1747: l_effective_date pay_payroll_actions.effective_date%type;
1748: l_business_group_id pay_payroll_actions.business_group_id%type;
1749: total_no_fields number;

Line 1746: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

1742: p_date between
1743: ptp.start_date and ptp.end_date;
1744:
1745: l_assignment_id pay_assignment_actions.assignment_id%type;
1746: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1747: l_effective_date pay_payroll_actions.effective_date%type;
1748: l_business_group_id pay_payroll_actions.business_group_id%type;
1749: total_no_fields number;
1750: l_payroll_id pay_payroll_actions.payroll_id%type;

Line 1752: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;

1748: l_business_group_id pay_payroll_actions.business_group_id%type;
1749: total_no_fields number;
1750: l_payroll_id pay_payroll_actions.payroll_id%type;
1751: l_person_id per_people_f.person_id%TYPE;
1752: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;
1753:
1754:
1755: cursor cur_person_id(p_assignment_action_id number) is
1756: select

Line 1759: pay_assignment_actions paa,

1755: cursor cur_person_id(p_assignment_action_id number) is
1756: select
1757: paf.person_id person_id
1758: from
1759: pay_assignment_actions paa,
1760: per_assignments_f paf
1761: where
1762: paa.assignment_action_id = p_assignment_action_id and
1763: paa.assignment_id = paf.assignment_id and

Line 2031: pay_assignment_actions paa,

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

Line 2049: pay_assignment_actions paa

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

Line 2103: l_latest_aaid pay_assignment_actions.assignment_action_id%TYPE

2099: l_roe_issuer pay_payrolls_f.prl_information4%TYPE;
2100: l_roe_correspondence_language per_people_f.full_name%TYPE;
2101: l_pay_period_end_date date;
2102: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
2103: l_latest_aaid pay_assignment_actions.assignment_action_id%TYPE
2104: := 0;
2105: l_latest_aaid_after_term pay_assignment_actions.assignment_action_id%TYPE
2106: := 0;
2107: l_period_end_date_after_term date;

Line 2105: l_latest_aaid_after_term pay_assignment_actions.assignment_action_id%TYPE

2101: l_pay_period_end_date date;
2102: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
2103: l_latest_aaid pay_assignment_actions.assignment_action_id%TYPE
2104: := 0;
2105: l_latest_aaid_after_term pay_assignment_actions.assignment_action_id%TYPE
2106: := 0;
2107: l_period_end_date_after_term date;
2108: l_period_start_date_after_term date;
2109:

Line 2116: pay_assignment_actions paa,

2112: p_tax_unit_id number) is
2113: select
2114: max(paa.assignment_action_id)
2115: from
2116: pay_assignment_actions paa,
2117: pay_payroll_actions ppa,
2118: per_assignments_f paf
2119: where
2120: paa.assignment_id = l_assignment_id and

Line 2169: l_serial_number pay_assignment_actions.serial_number%TYPE;

2165: l_tax_unit_id tax_unit_id
2166: from
2167: dual;
2168:
2169: l_serial_number pay_assignment_actions.serial_number%TYPE;
2170:
2171: begin
2172:
2173: hr_utility.trace('Archive data');