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_EYU dependencies on PAY_PAYROLL_ACTIONS

Line 1353: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa

1349: is
1350: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;
1351:
1352: cursor csr_reversal is
1353: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
1354: where paa.assignment_action_id = p_last_asg_action_id
1355: and paa.payroll_action_id = ppa.payroll_action_id
1356: and ACTION_TYPE in ('V');
1357:

Line 2542: from pay_payroll_actions pact,

2538: decode(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
2539: nvl(upper(substr(hoi.org_information6,1,13)),' ') acc_ref_no,
2540: hoi.org_information7 econ
2541:
2542: from pay_payroll_actions pact,
2543: hr_organization_information hoi
2544: where pact.payroll_action_id=pactid
2545: and pact.business_group_id = hoi.organization_id
2546: and hoi.org_information_context = 'Tax Details References'

Line 2916: FROM pay_payroll_actions ppa, pay_assignment_actions paa

2912:
2913: -- To fetch Effective date
2914: CURSOR get_effective_date IS
2915: SELECT ppa.effective_date
2916: FROM pay_payroll_actions ppa, pay_assignment_actions paa
2917: WHERE ppa.payroll_action_id = paa.payroll_action_id
2918: AND paa.assignment_action_id = p_assactid;
2919:
2920: --Declarations

Line 3571: from pay_payroll_actions ppa

3567: cursor csr_parameter_info is
3568: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
3569: /*ppa.effective_date*/
3570: sysdate
3571: from pay_payroll_actions ppa
3572: ,pay_assignment_actions paa
3573: where paa.assignment_action_id = c_assignment_action_id
3574: and ppa.payroll_action_id = paa.payroll_action_id;
3575:

Line 3798: || 'pay_payroll_actions ppa '|| 'where ppa.payroll_action_id = :payroll_action_id '

3794: BEGIN
3795: hr_utility.set_location('Entering: '||l_proc,1);
3796:
3797: sqlstr := 'select distinct PERSON_ID '|| 'from per_all_people_f ppf, '
3798: || 'pay_payroll_actions ppa '|| 'where ppa.payroll_action_id = :payroll_action_id '
3799: || 'and ppa.business_group_id = ppf.business_group_id '
3800: || ' order by person_id';
3801:
3802: hr_utility.trace(' Range Cursor Statement : '||sqlstr);

Line 3845: FROM pay_payroll_actions pact

3841: SELECT
3842: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
3843: effective_date,
3844: business_group_id
3845: FROM pay_payroll_actions pact
3846: WHERE payroll_action_id = pactid;
3847:
3848: CURSOR csr_asg is
3849: select distinct asg.assignment_id assignment_id,trim(pap.per_information10) per_agg_flag,trim(pap.per_information9) per_ni_flag,

Line 3886: pay_payroll_actions ppa

3882:
3883: --Cursor to fetch Latest FPS Run date for the assignment
3884: cursor csr_latest_fps_date(asg_id number) is select ppa.effective_date,ppa.payroll_action_id
3885: from pay_assignment_actions paa,
3886: pay_payroll_actions ppa
3887: where paa.assignment_id = asg_id
3888: and paa.action_status ='C'
3889: and ppa.action_type ='X'
3890: and ppa.payroll_action_id = paa.payroll_action_id

Line 3897: select paa.ASSIGNMENT_ACTION_ID , ppa.EFFECTIVE_DATE from pay_payroll_actions ppa,pay_assignment_actions paa

3893: and UPPER(l_tax_ref) = UPPER(SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'TAX_REF'),1,20))
3894: order by ppa.effective_date desc;
3895:
3896: CURSOR csr_latest_asg_action1(asg_id number,p_pact_id number) is
3897: select paa.ASSIGNMENT_ACTION_ID , ppa.EFFECTIVE_DATE from pay_payroll_actions ppa,pay_assignment_actions paa
3898: where ASSIGNMENT_ID = asg_id
3899: and ppa.ACTION_TYPE in ('Q','R','B','I','V','P','U')
3900: AND paa.action_status IN ('C', 'S')
3901: and ppa.PAYROLL_ACTION_ID = paa.PAYROLL_ACTION_ID

Line 3914: , pay_payroll_actions pact

3910: , '0')
3911: || paa.assignment_action_id), 16))
3912: , max (pact.effective_date) effective_date
3913: FROM pay_assignment_actions paa
3914: , pay_payroll_actions pact
3915: , per_time_periods ptp
3916: WHERE paa.assignment_id = asg_id
3917: AND paa.payroll_action_id = pact.payroll_action_id
3918: AND pact.time_period_id = ptp.time_period_id

Line 3929: FROM pay_payroll_actions pact, pay_assignment_actions paa

3925:
3926: cursor csr_action_type (l_asg_act_id number) is
3927: SELECT
3928: pact.action_type
3929: FROM pay_payroll_actions pact, pay_assignment_actions paa
3930: WHERE paa.ASSIGNMENT_ACTION_ID = l_asg_act_id
3931: and paa.payroll_action_id = pact.payroll_action_id;
3932:
3933: cursor csr_all_actions_after_fps (asg_id number, p_pact_id number) is

Line 3934: select paa.ASSIGNMENT_ACTION_ID asg_act_id from pay_payroll_actions ppa,pay_assignment_actions paa,

3930: WHERE paa.ASSIGNMENT_ACTION_ID = l_asg_act_id
3931: and paa.payroll_action_id = pact.payroll_action_id;
3932:
3933: cursor csr_all_actions_after_fps (asg_id number, p_pact_id number) is
3934: select paa.ASSIGNMENT_ACTION_ID asg_act_id from pay_payroll_actions ppa,pay_assignment_actions paa,
3935: per_all_assignments_f paaf,
3936: pay_all_payrolls_f pay,
3937: hr_soft_coding_keyflex sck
3938: where paa.ASSIGNMENT_ID = asg_id

Line 3961: , pay_payroll_actions pact

3957:
3958: cursor csr_all_actions_tax_year (asg_id number)is
3959: select paa.assignment_action_id asg_act_id
3960: FROM pay_assignment_actions paa
3961: , pay_payroll_actions pact
3962: , per_time_periods ptp,
3963: per_all_assignments_f paaf,
3964: pay_all_payrolls_f pay,
3965: hr_soft_coding_keyflex sck

Line 3991: select paa.ASSIGNMENT_ACTION_ID asg_act_id from per_all_assignments_f paaf, pay_payroll_actions ppa,pay_assignment_actions paa,

3987: AND g_end_year;
3988:
3989:
3990: cursor csr_all_actions_after_fps_agg (per_id number, p_pact_id number) is
3991: select paa.ASSIGNMENT_ACTION_ID asg_act_id from per_all_assignments_f paaf, pay_payroll_actions ppa,pay_assignment_actions paa,
3992: pay_all_payrolls_f pay,
3993: hr_soft_coding_keyflex sck
3994: where paaf.person_ID = per_id
3995: and paa.assignment_id = paaf.assignment_id

Line 4018: , pay_payroll_actions pact

4014: cursor csr_all_actions_tax_year_agg (per_id number)is
4015: select paa.ASSIGNMENT_ACTION_ID asg_act_id
4016: FROM per_all_assignments_f paaf,
4017: pay_assignment_actions paa
4018: , pay_payroll_actions pact
4019: , per_time_periods ptp,
4020: pay_all_payrolls_f pay,
4021: hr_soft_coding_keyflex sck
4022: WHERE paa.assignment_id = paaf.assignment_id

Line 4055: , pay_payroll_actions pact

4051: , max (pact.effective_date) effective_date
4052:
4053: FROM per_all_assignments_f paaf,
4054: pay_assignment_actions paa
4055: , pay_payroll_actions pact
4056: , per_time_periods ptp,
4057: pay_all_payrolls_f pay,
4058: hr_soft_coding_keyflex sck
4059: WHERE paa.assignment_id = paaf.assignment_id

Line 4092: , pay_payroll_actions pact

4088: , max (pact.effective_date) effective_date
4089:
4090: FROM per_all_assignments_f paaf,
4091: pay_assignment_actions paa
4092: , pay_payroll_actions pact
4093: , per_time_periods ptp,
4094: pay_all_payrolls_f pay,
4095: hr_soft_coding_keyflex sck
4096: WHERE paa.assignment_id = paaf.assignment_id

Line 4603: FROM pay_payroll_actions

4599: CURSOR csr_parameter_info(p_payroll_action_id NUMBER)
4600: IS
4601: SELECT
4602: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref
4603: FROM pay_payroll_actions
4604: WHERE payroll_action_id = p_payroll_action_id;
4605:
4606: CURSOR csr_payroll_details(pactid NUMBER)
4607: IS

Line 4617: FROM pay_payroll_actions pact,

4613: lpad(NVL(SUBSTR(hoi.org_information1,1,3),' '),3,0) tax_office_no,
4614: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
4615: NVL(upper(SUBSTR(hoi.org_information6,1,13)),' ') acc_ref_no,
4616: report_type
4617: FROM pay_payroll_actions pact,
4618: hr_organization_information hoi
4619: WHERE pact.payroll_action_id =pactid
4620: AND pact.business_group_id = hoi.organization_id
4621: AND hoi.org_information_context = 'Tax Details References'

Line 5375: , pay_payroll_actions pact

5371: , '0')
5372: || paa.assignment_action_id), 16))
5373: , max (pact.effective_date) effective_date
5374: FROM pay_assignment_actions paa
5375: , pay_payroll_actions pact
5376: , per_time_periods ptp
5377: WHERE paa.assignment_id = asg_id
5378: AND paa.payroll_action_id = pact.payroll_action_id
5379: AND pact.time_period_id = ptp.time_period_id

Line 5398: , pay_payroll_actions pact

5394: , max (pact.effective_date) effective_date
5395:
5396: FROM per_all_assignments_f paaf,
5397: pay_assignment_actions paa
5398: , pay_payroll_actions pact
5399: , per_time_periods ptp,
5400: pay_all_payrolls_f pay,
5401: hr_soft_coding_keyflex sck
5402: WHERE paa.assignment_id = paaf.assignment_id

Line 5427: pay_payroll_actions ppa

5423: --Cursor to fetch Latest FPS Run date and Payroll action ID for the assignment
5424: cursor csr_latest_fps(asg_id number) is
5425: select ppa.effective_date,ppa.payroll_action_id,ppa.report_type
5426: from pay_assignment_actions paa,
5427: pay_payroll_actions ppa
5428: where paa.assignment_id = asg_id
5429: and paa.action_status ='C'
5430: and ppa.payroll_action_id = paa.payroll_action_id
5431: and ppa.report_type in ( 'RTI_FPS_REP' , 'RTI_EYU_REP_13')

Line 5439: pay_payroll_actions ppa,

5435: --cursor to get person latest fps run
5436: cursor csr_latest_fps_payeagg(per_id number) is
5437: select ppa.effective_date,ppa.payroll_action_id,ppa.report_type
5438: from pay_assignment_actions paa,
5439: pay_payroll_actions ppa,
5440: per_all_assignments_f paaf ,
5441: pay_all_payrolls_f pay,
5442: hr_soft_coding_keyflex sck
5443: where paaf.person_id = per_id

Line 5481: pay_payroll_actions ppa

5477:
5478: cursor csr_fps_check(p_asg_id number) is
5479: select count(*)
5480: from pay_assignment_actions paa,
5481: pay_payroll_actions ppa
5482: where paa.assignment_id = p_asg_id
5483: and paa.action_status ='C'
5484: and paa.assignment_action_id <> p_assactid
5485: and ppa.payroll_action_id = paa.payroll_action_id

Line 5738: FROM pay_payroll_actions pact

5734: l_error_flag VARCHAR2(1);
5735: CURSOR csr_is_etext_report
5736: IS
5737: SELECT report_type
5738: FROM pay_payroll_actions pact
5739: WHERE pact.payroll_action_id = pactid;
5740: l_is_etext_report VARCHAR2(50);
5741: l_request_id fnd_concurrent_requests.request_id%TYPE;
5742: xml_layout BOOLEAN;

Line 5763: FROM pay_payroll_actions pact,

5759: hoi.org_information7 econ_number,
5760: pact.business_group_id bus_grp_id,
5761: pact.action_parameter_group_id act_param_grp_id,
5762: org_information19 service_company
5763: FROM pay_payroll_actions pact,
5764: hr_organization_information hoi
5765: WHERE pact.payroll_action_id =pactid
5766: AND pact.business_group_id = hoi.organization_id
5767: AND hoi.org_information_context = 'Tax Details References'

Line 5804: FROM pay_payroll_actions pact

5800: SELECT legislative_parameters para,
5801: fnd_number.number_to_canonical(request_id) control_id,
5802: report_type,
5803: business_group_id
5804: FROM pay_payroll_actions pact
5805: WHERE payroll_action_id = pactid;
5806:
5807: CURSOR csr_header_det(p_bus_id NUMBER, p_tax_ref VARCHAR2)
5808: IS

Line 5822: from pay_payrolls_f ppf,pay_payroll_actions ppa

5818:
5819: CURSOR csr_payroll_details
5820: IS
5821: SELECT ppf.PAYROLL_NAME
5822: from pay_payrolls_f ppf,pay_payroll_actions ppa
5823: WHERE ppa.payroll_action_id = pactid
5824: and ppf.payroll_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PAYROLL'),1,20);
5825:
5826: -- Cursor to fetch Errored Records

Line 5831: FROM pay_payroll_actions ppa,

5827: CURSOR get_asg_action_id_error
5828: IS
5829: SELECT DISTINCT paa.assignment_action_id asg_action_id,
5830: assignment_id
5831: FROM pay_payroll_actions ppa,
5832: pay_assignment_actions paa
5833: WHERE ppa.payroll_action_id = pactid -- pact_id
5834: AND paa.payroll_action_id = ppa.payroll_action_id
5835: AND paa.action_status = 'E';

Line 5976: FROM pay_payroll_actions ppa,

5972: CURSOR get_asg_action_id
5973: IS
5974: SELECT DISTINCT paa.assignment_action_id asg_action_id,
5975: assignment_id
5976: FROM pay_payroll_actions ppa,
5977: pay_assignment_actions paa
5978: WHERE ppa.payroll_action_id = pactid -- pact_id
5979: AND paa.payroll_action_id = ppa.payroll_action_id
5980: AND paa.action_status = 'C';

Line 5987: FROM pay_payroll_actions ppa,

5983: CURSOR get_asg_action_id_error
5984: IS
5985: SELECT DISTINCT paa.assignment_action_id asg_action_id,
5986: assignment_id
5987: FROM pay_payroll_actions ppa,
5988: pay_assignment_actions paa
5989: WHERE ppa.payroll_action_id = pactid -- pact_id
5990: AND paa.payroll_action_id = ppa.payroll_action_id
5991: AND paa.action_status = 'E';

Line 6121: FROM pay_payroll_actions ppa,

6117:
6118: CURSOR get_person_count
6119: IS
6120: SELECT COUNT(DISTINCT(paaf.person_id))
6121: FROM pay_payroll_actions ppa,
6122: pay_assignment_actions paa,
6123: per_all_assignments_f paaf
6124: WHERE ppa.payroll_action_id = pactid -- pact_id
6125: AND paa.payroll_action_id = ppa.payroll_action_id