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_PAYROLL_ACTIONS

Line 233: pay_payroll_actions

229: cursor cur_payroll_actions is
230: select
231: legislative_parameters
232: from
233: pay_payroll_actions
234: where
235: payroll_action_id = pactid;
236:
237: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

Line 237: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

233: pay_payroll_actions
234: where
235: payroll_action_id = pactid;
236:
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;

Line 240: l_assignment_set_id pay_payroll_actions.assignment_set_id%TYPE;

236:
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');

Line 270: pay_payroll_actions ppa

266: distinct paf.person_id
267: from
268: hr_assignment_set_amendments hasa,
269: per_assignments_f paf,
270: pay_payroll_actions ppa
271: WHERE
272: hasa.assignment_set_id =
273: pycadar_pkg.get_parameter(''ASSIGNMENT_SET_ID'',ppa.legislative_parameters) and
274: hasa.include_or_exclude = ''I'' and

Line 290: from pay_payroll_actions ppa

286: -- has 'PERSON_ID= '
287:
288: str := 'select
289: fnd_number.canonical_to_number(substr(legislative_parameters,11,(decode(instr(legislative_parameters,'' ''),0,10,instr(legislative_parameters,'' '')-11))))
290: from pay_payroll_actions ppa
291: where ppa.payroll_action_id=:pactid';
292:
293: end if;
294:

Line 683: pay_payroll_actions ppa,

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
687: and paa.payroll_action_id = ppa.payroll_action_id

Line 795: pay_payroll_actions

791: CURSOR cur_bg_id IS
792: SELECT
793: business_group_id
794: FROM
795: pay_payroll_actions
796: WHERE
797: payroll_action_id = p_payroll_action_id;
798:
799: l_bg_id per_business_groups.business_group_id%TYPE;

Line 861: pay_payroll_actions

857: legislative_parameters,
858: effective_date,
859: business_group_id
860: from
861: pay_payroll_actions
862: where
863: payroll_action_id = pactid;
864:
865: l_start_date DATE;

Line 867: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

863: payroll_action_id = pactid;
864:
865: l_start_date DATE;
866:
867: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
868: str varchar2(1000);
869: l_person_id per_people_f.person_id%type;
870: l_assignment_set_id pay_payroll_actions.assignment_set_id%type;
871: l_effective_date pay_payroll_actions.effective_date%type;

Line 870: l_assignment_set_id pay_payroll_actions.assignment_set_id%type;

866:
867: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
868: str varchar2(1000);
869: l_person_id per_people_f.person_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;

Line 871: l_effective_date pay_payroll_actions.effective_date%type;

867: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
868: str varchar2(1000);
869: l_person_id per_people_f.person_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:

Line 872: l_effective_date1 pay_payroll_actions.effective_date%type;

868: str varchar2(1000);
869: l_person_id per_people_f.person_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

Line 873: l_business_group_id pay_payroll_actions.business_group_id%type;

869: l_person_id per_people_f.person_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

Line 919: pay_payroll_actions ppa,

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
923: ppa.payroll_action_id = paa.payroll_action_id and

Line 938: pay_payroll_actions ppa,

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
942: ppa.payroll_action_id = paa.payroll_action_id and

Line 955: pay_payroll_actions ppa_t4,

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
959: ppa_t4.payroll_action_id = paa_t4.payroll_action_id and

Line 1080: pay_payroll_actions ppa,

1076: cursor cur_retry is
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

Line 1653: pay_payroll_actions ppa,

1649: cursor cur_edor is
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

Line 1724: pay_payroll_actions ppa,

1720: ppa.payroll_id,
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;

Line 1743: l_effective_date pay_payroll_actions.effective_date%type;

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;
1747: l_person_id per_people_f.person_id%TYPE;

Line 1744: l_business_group_id pay_payroll_actions.business_group_id%type;

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;
1747: l_person_id per_people_f.person_id%TYPE;
1748: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;

Line 1746: l_payroll_id pay_payroll_actions.payroll_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;
1747: l_person_id per_people_f.person_id%TYPE;
1748: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;
1749:
1750:

Line 2026: from pay_payroll_actions ppa,

2022:
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

Line 2044: from pay_payroll_actions ppa,

2040:
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')

Line 2076: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE; l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

2072: l_roe_comment varchar2(150);
2073: l_last_day_paid date;
2074: l_last_day_paid1 date;
2075: l_last_day_paid2 date;
2076: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE; l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
2077:
2078: CURSOR cur_asg_set_name IS
2079: SELECT
2080: assignment_set_name

Line 2113: pay_payroll_actions ppa,

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
2117: paa.tax_unit_id = p_tax_unit_id and