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

Line 295: FROM pay_assignment_actions act,

291: decode(pap.per_information9,'Y','Y',NULL) multiple_asg_flag,
292: current_employee_flag,
293: pap.effective_start_date effective_start_date,
294: serv.actual_termination_date actual_termination_date
295: FROM pay_assignment_actions act,
296: per_all_assignments_f paa,
297: per_all_people_f pap,
298: per_periods_of_service serv,
299: per_assignment_status_types past

Line 328: FROM pay_assignment_actions act,

324: decode(pap.per_information9,'Y','Y',NULL) multiple_asg_flag,
325: current_employee_flag,
326: pap.effective_start_date effective_start_date,
327: serv.actual_termination_date actual_termination_date
328: FROM pay_assignment_actions act,
329: per_all_assignments_f paa,
330: per_all_people_f pap,
331: per_periods_of_service serv,
332: per_assignment_status_types past

Line 903: pay_assignment_actions paa

899: select substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
900: to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'START=') + 6,10),'YYYY-MM-DD') effective_date,
901: business_group_id
902: from pay_payroll_actions pact,
903: pay_assignment_actions paa
904: where paa.assignment_action_id = p_assactid
905: and pact.payroll_action_id = paa.payroll_action_id;
906:
907: cursor csr_check_cont_emp(p_person_id number,p_tax_ref varchar2) is

Line 1155: FROM pay_payroll_actions ppa, pay_assignment_actions paa

1151: edi_validation_fail out nocopy varchar2) IS
1152:
1153: CURSOR get_effective_date IS
1154: SELECT ppa.effective_date
1155: FROM pay_payroll_actions ppa, pay_assignment_actions paa
1156: WHERE ppa.payroll_action_id = paa.payroll_action_id
1157: AND paa.assignment_action_id = p_assactid;
1158:
1159: l_proc CONSTANT VARCHAR2(50):= g_package||'eas_asg_etext_validations';

Line 2594: select pay_assignment_actions_s.nextval

2590: if (l_flag = 'Y') then
2591:
2592: -- Create one assignment action for every assignment
2593: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
2594: select pay_assignment_actions_s.nextval
2595: into lockingactid
2596: from dual;
2597:
2598: -- Insert assignment into pay_assignment_actions

Line 2598: -- Insert assignment into pay_assignment_actions

2594: select pay_assignment_actions_s.nextval
2595: into lockingactid
2596: from dual;
2597:
2598: -- Insert assignment into pay_assignment_actions
2599: hr_nonrun_asact.insact
2600: (
2601: lockingactid,
2602: asg_rec.assignment_id,

Line 2653: select pay_assignment_actions_s.nextval

2649: if l_flag = 'Y' then
2650:
2651: -- Create one assignment action for every assignment
2652: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
2653: select pay_assignment_actions_s.nextval
2654: into lockingactid
2655: from dual;
2656:
2657: -- Insert assignment into pay_assignment_actions

Line 2657: -- Insert assignment into pay_assignment_actions

2653: select pay_assignment_actions_s.nextval
2654: into lockingactid
2655: from dual;
2656:
2657: -- Insert assignment into pay_assignment_actions
2658: hr_nonrun_asact.insact
2659: (
2660: lockingactid,
2661: asg_rec.assignment_id,

Line 2814: select pay_assignment_actions_s.nextval

2810: if l_flag = 'Y' then
2811:
2812: -- Create one assignment action for every assignment
2813: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
2814: select pay_assignment_actions_s.nextval
2815: into lockingactid
2816: from dual;
2817:
2818: -- Insert assignment into pay_assignment_actions

Line 2818: -- Insert assignment into pay_assignment_actions

2814: select pay_assignment_actions_s.nextval
2815: into lockingactid
2816: from dual;
2817:
2818: -- Insert assignment into pay_assignment_actions
2819: hr_nonrun_asact.insact
2820: (
2821: lockingactid,
2822: asg_rec.assignment_id,

Line 3032: from pay_assignment_actions paa,

3028:
3029: cursor csr_archive_type is
3030: select report_type,paa.payroll_action_id,BUSINESS_GROUP_ID,
3031: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref
3032: from pay_assignment_actions paa,
3033: pay_payroll_actions ppa
3034: where paa.assignment_action_id = p_assactid
3035: and paa.payroll_action_id = ppa.payroll_action_id;
3036:

Line 3040: from pay_assignment_actions paa

3036:
3037: cursor get_already_processed_asg(p_pact_id number,p_person_id number,p_business_group_id number,p_effective_date date)
3038: is
3039: select min(paa.assignment_action_id)
3040: from pay_assignment_actions paa
3041: where
3042: paa.payroll_action_id = p_pact_id
3043: and paa.action_status = 'C'
3044: and paa.assignment_id in(

Line 3061: pay_assignment_actions paa,

3057: cursor processed_asg(p_business_group_id number,p_assignment_id number,p_tax_ref varchar2,p_effective_date date)
3058: is
3059: select distinct ppa.payroll_action_id
3060: from pay_payroll_actions ppa,
3061: pay_assignment_actions paa,
3062: per_all_assignments_f asg1,
3063: per_all_assignments_f asg2
3064: where asg1.assignment_id = p_assignment_id
3065: and asg1.person_id = asg2.person_id

Line 3634: pay_assignment_actions paa

3630: cursor get_asg_action_id is
3631: select distinct paa.assignment_action_id asg_action_id, paa.assignment_id
3632: , paaf.assignment_number
3633: from pay_payroll_actions ppa,
3634: pay_assignment_actions paa
3635: , per_all_assignments_f paaf
3636: where ppa.payroll_action_id = pactid -- pact_id
3637: and paa.payroll_action_id = ppa.payroll_action_id
3638: and paa.action_status = 'C'

Line 3653: pay_assignment_actions paa

3649: cursor get_asg_action_id_error is
3650: select distinct paa.assignment_action_id asg_action_id, paa.assignment_id
3651: , paaf.assignment_number
3652: from pay_payroll_actions ppa,
3653: pay_assignment_actions paa
3654: , per_all_assignments_f paaf
3655: where ppa.payroll_action_id = pactid -- pact_id
3656: and paa.payroll_action_id = ppa.payroll_action_id
3657: and paa.action_status = 'E'

Line 3688: pay_assignment_actions paa

3684: to_char(to_date(substr(pai_asg.action_information6,1,10),'YYYY-MM-DD'),'DD-MON-RRRR') end_date,
3685: pai_emp.action_information17 emp_no2
3686: from pay_action_information pai_emp,
3687: pay_action_information pai_asg,
3688: pay_assignment_actions paa
3689: where paa.payroll_action_id = pactid and paa.ACTION_STATUS = 'C' and paa.assignment_id = c_assignment_id
3690: and pai_emp.action_context_id = paa.assignment_action_id
3691: and pai_emp.action_information_category = 'GB RTI EMPLOYEE DETAILS'
3692: and pai_emp.action_context_type = 'AAP'

Line 3963: pay_assignment_actions paa,

3959:
3960: cursor get_person_count is
3961: select count(distinct(paaf.person_id))
3962: from pay_payroll_actions ppa,
3963: pay_assignment_actions paa,
3964: per_all_assignments_f paaf
3965: where ppa.payroll_action_id = pactid -- pact_id
3966: and paa.payroll_action_id = ppa.payroll_action_id
3967: and paa.action_status = 'C'

Line 4142: ,pay_assignment_actions paa

4138: cursor csr_parameter_info is
4139: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
4140: NVL(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'START')),sysdate)
4141: from pay_payroll_actions ppa
4142: ,pay_assignment_actions paa
4143: where paa.assignment_action_id = c_assignment_action_id
4144: and ppa.payroll_action_id = paa.payroll_action_id;
4145:
4146: l_date_valid DATE;