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 237: pay_payroll_actions

233: cursor cur_payroll_actions is
234: select
235: legislative_parameters
236: from
237: pay_payroll_actions
238: where
239: payroll_action_id = pactid;
240:
241: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

Line 241: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

237: pay_payroll_actions
238: where
239: payroll_action_id = pactid;
240:
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;

Line 244: l_assignment_set_id pay_payroll_actions.assignment_set_id%TYPE;

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

Line 274: pay_payroll_actions ppa

270: distinct paf.person_id
271: from
272: hr_assignment_set_amendments hasa,
273: per_assignments_f paf,
274: pay_payroll_actions ppa
275: WHERE
276: hasa.assignment_set_id =
277: pycadar_pkg.get_parameter(''ASSIGNMENT_SET_ID'',ppa.legislative_parameters) and
278: hasa.include_or_exclude = ''I'' and

Line 294: from pay_payroll_actions ppa

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

Line 687: pay_payroll_actions ppa,

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

Line 799: pay_payroll_actions

795: CURSOR cur_bg_id IS
796: SELECT
797: business_group_id
798: FROM
799: pay_payroll_actions
800: WHERE
801: payroll_action_id = p_payroll_action_id;
802:
803: l_bg_id per_business_groups.business_group_id%TYPE;

Line 865: pay_payroll_actions

861: legislative_parameters,
862: effective_date,
863: business_group_id
864: from
865: pay_payroll_actions
866: where
867: payroll_action_id = pactid;
868:
869: l_start_date DATE;

Line 871: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

867: payroll_action_id = pactid;
868:
869: l_start_date DATE;
870:
871: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
872: str varchar2(1000);
873: l_person_id per_people_f.person_id%type;
874: l_assignment_set_id pay_payroll_actions.assignment_set_id%type;
875: l_effective_date pay_payroll_actions.effective_date%type;

Line 874: l_assignment_set_id pay_payroll_actions.assignment_set_id%type;

870:
871: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
872: str varchar2(1000);
873: l_person_id per_people_f.person_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;

Line 875: l_effective_date pay_payroll_actions.effective_date%type;

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

Line 876: l_effective_date1 pay_payroll_actions.effective_date%type;

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

Line 877: l_business_group_id pay_payroll_actions.business_group_id%type;

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

Line 923: pay_payroll_actions ppa,

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

Line 942: pay_payroll_actions ppa,

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

Line 959: pay_payroll_actions ppa_t4,

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

Line 1084: pay_payroll_actions ppa,

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

Line 1657: pay_payroll_actions ppa,

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

Line 1728: pay_payroll_actions ppa,

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

Line 1747: l_effective_date pay_payroll_actions.effective_date%type;

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

Line 1748: l_business_group_id pay_payroll_actions.business_group_id%type;

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

Line 1750: l_payroll_id pay_payroll_actions.payroll_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;
1751: l_person_id per_people_f.person_id%TYPE;
1752: l_assignment_amend pay_assignment_actions.assignment_action_id%TYPE;
1753:
1754:

Line 2030: from pay_payroll_actions ppa,

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

Line 2048: from pay_payroll_actions ppa,

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

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

2076: l_roe_comment varchar2(150);
2077: l_last_day_paid date;
2078: l_last_day_paid1 date;
2079: l_last_day_paid2 date;
2080: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE; l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
2081:
2082: CURSOR cur_asg_set_name IS
2083: SELECT
2084: assignment_set_name

Line 2117: pay_payroll_actions ppa,

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