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

Line 351: FROM pay_assignment_actions act,

347: decode(pap.per_information9,'Y','Y',NULL) multiple_asg_flag,
348: current_employee_flag,
349: pap.effective_start_date effective_start_date,
350: serv.actual_termination_date actual_termination_date
351: FROM pay_assignment_actions act,
352: per_all_assignments_f paa,
353: per_all_people_f pap,
354: per_periods_of_service serv,
355: per_assignment_status_types past

Line 384: FROM pay_assignment_actions act,

380: decode(pap.per_information9,'Y','Y',NULL) multiple_asg_flag,
381: current_employee_flag,
382: pap.effective_start_date effective_start_date,
383: serv.actual_termination_date actual_termination_date
384: FROM pay_assignment_actions act,
385: per_all_assignments_f paa,
386: per_all_people_f pap,
387: per_periods_of_service serv,
388: per_assignment_status_types past

Line 517: pay_assignment_actions paa

513: cursor csr_parameter_info is
514: select substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
515: to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'START=') + 6,10),'YYYY-MM-DD') effective_date
516: from pay_payroll_actions pact,
517: pay_assignment_actions paa
518: where paa.assignment_action_id = p_assactid
519: and pact.payroll_action_id = paa.payroll_action_id;
520:
521: cursor csr_check_cont_emp(p_person_id number,p_tax_ref varchar2) is

Line 742: FROM pay_payroll_actions ppa, pay_assignment_actions paa

738: edi_validation_fail out nocopy varchar2) IS
739:
740: CURSOR get_effective_date IS
741: SELECT ppa.effective_date
742: FROM pay_payroll_actions ppa, pay_assignment_actions paa
743: WHERE ppa.payroll_action_id = paa.payroll_action_id
744: AND paa.assignment_action_id = p_assactid;
745:
746: l_proc CONSTANT VARCHAR2(50):= g_package||'eas_asg_etext_validations';

Line 1946: select pay_assignment_actions_s.nextval

1942: if l_flag = 'Y' then
1943:
1944: -- Create one assignment action for every assignment
1945: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
1946: select pay_assignment_actions_s.nextval
1947: into lockingactid
1948: from dual;
1949:
1950: -- Insert assignment into pay_assignment_actions

Line 1950: -- Insert assignment into pay_assignment_actions

1946: select pay_assignment_actions_s.nextval
1947: into lockingactid
1948: from dual;
1949:
1950: -- Insert assignment into pay_assignment_actions
1951: hr_nonrun_asact.insact
1952: (
1953: lockingactid,
1954: asg_rec.assignment_id,

Line 2003: select pay_assignment_actions_s.nextval

1999: if l_flag = 'Y' then
2000:
2001: -- Create one assignment action for every assignment
2002: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
2003: select pay_assignment_actions_s.nextval
2004: into lockingactid
2005: from dual;
2006:
2007: -- Insert assignment into pay_assignment_actions

Line 2007: -- Insert assignment into pay_assignment_actions

2003: select pay_assignment_actions_s.nextval
2004: into lockingactid
2005: from dual;
2006:
2007: -- Insert assignment into pay_assignment_actions
2008: hr_nonrun_asact.insact
2009: (
2010: lockingactid,
2011: asg_rec.assignment_id,

Line 2178: select pay_assignment_actions_s.nextval

2174: if l_flag = 'Y' then
2175:
2176: -- Create one assignment action for every assignment
2177: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
2178: select pay_assignment_actions_s.nextval
2179: into lockingactid
2180: from dual;
2181:
2182: -- Insert assignment into pay_assignment_actions

Line 2182: -- Insert assignment into pay_assignment_actions

2178: select pay_assignment_actions_s.nextval
2179: into lockingactid
2180: from dual;
2181:
2182: -- Insert assignment into pay_assignment_actions
2183: hr_nonrun_asact.insact
2184: (
2185: lockingactid,
2186: asg_rec.assignment_id,

Line 2361: from pay_assignment_actions paa,

2357:
2358: cursor csr_archive_type is
2359: select report_type,paa.payroll_action_id,
2360: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref
2361: from pay_assignment_actions paa,
2362: pay_payroll_actions ppa
2363: where paa.assignment_action_id = p_assactid
2364: and paa.payroll_action_id = ppa.payroll_action_id;
2365:

Line 2783: pay_assignment_actions paa

2779: -- Cursor to fetch Completed records
2780: cursor get_asg_action_id is
2781: select distinct paa.assignment_action_id asg_action_id, assignment_id
2782: from pay_payroll_actions ppa,
2783: pay_assignment_actions paa
2784: where ppa.payroll_action_id = pactid -- pact_id
2785: and paa.payroll_action_id = ppa.payroll_action_id
2786: and paa.action_status = 'C';
2787: -- Cursor to fetch Errored Records

Line 2791: pay_assignment_actions paa

2787: -- Cursor to fetch Errored Records
2788: cursor get_asg_action_id_error is
2789: select distinct paa.assignment_action_id asg_action_id, assignment_id
2790: from pay_payroll_actions ppa,
2791: pay_assignment_actions paa
2792: where ppa.payroll_action_id = pactid -- pact_id
2793: and paa.payroll_action_id = ppa.payroll_action_id
2794: and paa.action_status = 'E';
2795: */

Line 2801: pay_assignment_actions paa

2797: cursor get_asg_action_id is
2798: select distinct paa.assignment_action_id asg_action_id, paa.assignment_id
2799: , paaf.assignment_number
2800: from pay_payroll_actions ppa,
2801: pay_assignment_actions paa
2802: , per_all_assignments_f paaf
2803: where ppa.payroll_action_id = pactid -- pact_id
2804: and paa.payroll_action_id = ppa.payroll_action_id
2805: and paa.action_status = 'C'

Line 2822: pay_assignment_actions paa

2818: cursor get_asg_action_id_error is
2819: select distinct paa.assignment_action_id asg_action_id, paa.assignment_id
2820: , paaf.assignment_number
2821: from pay_payroll_actions ppa,
2822: pay_assignment_actions paa
2823: , per_all_assignments_f paaf
2824: where ppa.payroll_action_id = pactid -- pact_id
2825: and paa.payroll_action_id = ppa.payroll_action_id
2826: and paa.action_status = 'E'

Line 2858: pay_assignment_actions paa

2854: to_char(to_date(substr(pai_asg.action_information6,1,10),'YYYY-MM-DD'),'DD-MON-RRRR') end_date,
2855: pai_emp.action_information17 emp_no2
2856: from pay_action_information pai_emp,
2857: pay_action_information pai_asg,
2858: pay_assignment_actions paa
2859: where paa.payroll_action_id = pactid and paa.ACTION_STATUS = 'C' and paa.assignment_id = c_assignment_id
2860: and pai_emp.action_context_id = paa.assignment_action_id
2861: and pai_emp.action_information_category = 'GB RTI EMPLOYEE DETAILS'
2862: and pai_emp.action_context_type = 'AAP'

Line 3076: pay_assignment_actions paa,

3072:
3073: cursor get_person_count is
3074: select count(distinct(paaf.person_id))
3075: from pay_payroll_actions ppa,
3076: pay_assignment_actions paa,
3077: per_all_assignments_f paaf
3078: where ppa.payroll_action_id = pactid -- pact_id
3079: and paa.payroll_action_id = ppa.payroll_action_id
3080: and paa.action_status = 'C'

Line 3245: ,pay_assignment_actions paa

3241: cursor csr_parameter_info is
3242: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
3243: NVL(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'START')),sysdate)
3244: from pay_payroll_actions ppa
3245: ,pay_assignment_actions paa
3246: where paa.assignment_action_id = c_assignment_action_id
3247: and ppa.payroll_action_id = paa.payroll_action_id;
3248:
3249: l_date_valid DATE;