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

Line 212: FROM pay_payroll_actions pact

208: SELECT to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
209: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
210: effective_date eff_date,
211: business_group_id bg_id
212: FROM pay_payroll_actions pact
213: WHERE payroll_action_id = p_pactid;
214:
215: cursor csr_payrolls(p_bg_id NUMBER, p_tax_ref VARCHAR2, p_end_year DATE) IS
216: SELECT

Line 645: FROM pay_payroll_actions ppa,

641: max(ptp.period_type),
642: max(ptp.period_num) max_period_number,
643: min(ptp.start_date) start_year,
644: max(ptp.end_date) end_year
645: FROM pay_payroll_actions ppa,
646: pay_assignment_actions paa,
647: per_time_periods ptp
648: WHERE assignment_action_id = p_last_asg_action_id
649: AND ppa.time_period_id = ptp.time_period_id

Line 671: FROM pay_payroll_actions pact

667:
668: CURSOR csr_parameter_info
669: IS
670: SELECT SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref
671: FROM pay_payroll_actions pact
672: WHERE payroll_action_id = p_pactid;
673:
674: CURSOR get_asg_active_range(p_asg_id NUMBER, p_tax_ref VARCHAR2) IS
675: SELECT min(paaf.effective_start_date) min_active,

Line 700: pay_payroll_actions ppa

696: asg.assignment_number assignment_number
697: FROM per_all_people_f pap,
698: per_all_assignments_f asg,
699: pay_assignment_actions paa,
700: pay_payroll_actions ppa
701: WHERE paa.assignment_action_id = p_last_asg_action_id
702: AND ppa.payroll_action_id = paa.payroll_action_id
703: AND paa.assignment_id = asg.assignment_id
704: AND pap.person_id = asg.person_id

Line 719: pay_payroll_actions pact,

715: || paa.assignment_action_id),16)) max_asg_act_id,
716: MAX(pact.effective_date) effective_date
717: FROM pay_assignment_actions paa,
718: per_all_assignments_f paaf,
719: pay_payroll_actions pact,
720: per_time_periods ptp
721: WHERE paa.assignment_id = paaf.assignment_id
722: AND paaf.person_id = p_person_id
723: AND paa.payroll_action_id = pact.payroll_action_id

Line 2085: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa

2081: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
2082: FROM dual;
2083:
2084: cursor csr_reversal is
2085: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
2086: where paa.assignment_action_id = l_last_asg_action_id
2087: and paa.payroll_action_id = ppa.payroll_action_id
2088: and ACTION_TYPE in ('V');
2089:

Line 2544: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa

2540: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
2541: FROM dual;
2542:
2543: cursor csr_reversal is
2544: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
2545: where paa.assignment_action_id = l_last_asg_action_id
2546: and paa.payroll_action_id = ppa.payroll_action_id
2547: and ACTION_TYPE in ('V');
2548:

Line 2811: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa

2807: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
2808: FROM dual;
2809:
2810: cursor csr_reversal is
2811: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
2812: where paa.assignment_action_id = l_last_asg_action_id
2813: and paa.payroll_action_id = ppa.payroll_action_id
2814: and ACTION_TYPE in ('V');
2815:

Line 3070: FROM pay_payroll_actions

3066: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3067: 'TEST'),1,1) test_indicator,
3068: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3069: 'UNIQUE_TEST_ID'),1,8) unique_test_id
3070: FROM pay_payroll_actions
3071: WHERE payroll_action_id = p_pact_id;
3072:
3073: cursor csr_payrolls(p_bg_id NUMBER, p_end_year DATE) IS
3074: SELECT

Line 3182: pay_payroll_actions ppa

3178: -- it must be ordered by person_id
3179: --
3180: sqlstr := 'SELECT DISTINCT person_id
3181: FROM per_all_people_f ppf,
3182: pay_payroll_actions ppa
3183: WHERE ppa.payroll_action_id = :payroll_action_id
3184: AND ppa.business_group_id +0= ppf.business_group_id
3185: --and rownum < 50
3186: ORDER BY ppf.person_id';

Line 3233: FROM pay_payroll_actions pact

3229: effective_date,
3230: business_group_id,
3231: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'ASG_SET'),1,20) asg_set_id
3232: -- fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date
3233: FROM pay_payroll_actions pact
3234: WHERE payroll_action_id = pactid;
3235:
3236: CURSOR csr_asg(c_asg_id NUMBER, c_effective_date DATE)
3237: IS

Line 3262: select EFFECTIVE_DATE from pay_payroll_actions where payroll_action_id = p_pre_pact_id;

3258:
3259:
3260: -- First FPS Cursors
3261: cursor csr_get_prepayment_date(p_pre_pact_id number) is
3262: select EFFECTIVE_DATE from pay_payroll_actions where payroll_action_id = p_pre_pact_id;
3263:
3264: --For RTIP60
3265: cursor csr_asg_details(c_tax_ref varchar2,c_eff_date date,c_asg_set_id number) is
3266: select distinct paaf.assignment_id assignment_id,

Line 3351: , pay_payroll_actions pact

3347: , '0')
3348: || paa.assignment_action_id), 16))
3349: , max (pact.effective_date) effective_date
3350: FROM pay_assignment_actions paa
3351: , pay_payroll_actions pact
3352: , per_time_periods ptp
3353: WHERE paa.assignment_id = p_asgid
3354: AND paa.payroll_action_id = pact.payroll_action_id
3355: --AND pact.payroll_id = l_payroll_id --commented for testing

Line 3626: FROM pay_payroll_actions

3622: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYROLL_ID'),1,20) payroll_id,
3623: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
3624: SUBSTR(pay_gb_eoy_archive.get_parameter (legislative_parameters, 'FIRST_FPS'), 1,1) first_fps
3625:
3626: FROM pay_payroll_actions
3627: WHERE payroll_action_id = p_payroll_action_id;
3628:
3629: cursor csr_prepayment_date(pre_pay_id number)
3630: is

Line 3634: pay_payroll_actions ppa

3630: is
3631: SELECT
3632: ppa.effective_date
3633: FROM
3634: pay_payroll_actions ppa
3635: WHERE
3636: ppa.payroll_action_id = pre_pay_id;
3637:
3638: CURSOR csr_pre_pact_eff_date(p_payroll_action_id NUMBER)

Line 3641: FROM pay_payroll_actions

3637:
3638: CURSOR csr_pre_pact_eff_date(p_payroll_action_id NUMBER)
3639: IS
3640: SELECT effective_date
3641: FROM pay_payroll_actions
3642: WHERE payroll_action_id = p_payroll_action_id;
3643:
3644: CURSOR csr_payroll_details(pactid NUMBER)
3645: IS

Line 3655: FROM pay_payroll_actions pact,

3651: lpad(NVL(SUBSTR(hoi.org_information1,1,3),' '),3,0) tax_office_no,
3652: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
3653: NVL(upper(SUBSTR(hoi.org_information6,1,13)),' ') acc_ref_no,
3654: report_type
3655: FROM pay_payroll_actions pact,
3656: hr_organization_information hoi
3657: WHERE pact.payroll_action_id =pactid
3658: AND pact.business_group_id = hoi.organization_id
3659: AND hoi.org_information_context = 'Tax Details References'

Line 3842: pay_payroll_actions ppa

3838: asg.assignment_number,
3839: asg.payroll_id
3840: FROM per_all_assignments_f asg,
3841: pay_assignment_actions paa,
3842: pay_payroll_actions ppa
3843: WHERE paa.assignment_action_id = c_asg_act_id
3844: AND paa.assignment_id = asg.assignment_id
3845: AND ppa.payroll_action_id = paa.payroll_action_id
3846: AND (ppa.effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 3882: , pay_payroll_actions pact

3878: , '0')
3879: || paa.assignment_action_id), 16))
3880: , max (pact.effective_date) effective_date
3881: FROM pay_assignment_actions paa
3882: , pay_payroll_actions pact
3883: , per_time_periods ptp
3884: WHERE paa.assignment_id = p_asgid
3885: AND paa.payroll_action_id = pact.payroll_action_id
3886: AND pact.payroll_id = l_payroll_id

Line 3904: FROM pay_payroll_actions pact,

3900: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
3901: effective_date eff_date,
3902: business_group_id bg_id,
3903: pact.payroll_action_id pactid
3904: FROM pay_payroll_actions pact,
3905: pay_assignment_actions paa
3906: WHERE paa.payroll_action_id = pact.payroll_action_id
3907: AND paa.assignment_action_id = p_assactid;
3908:

Line 3936: FROM pay_payroll_actions ppa, --Current pactid

3932: IS
3933:
3934: SELECT count(distinct act.assignment_action_id),
3935: max(act.assignment_action_id) assignment_action_id
3936: FROM pay_payroll_actions ppa, --Current pactid
3937: pay_payroll_actions appa, --Payroll Run
3938: pay_payroll_actions appa2, --Prepayments
3939: pay_assignment_actions act, --Payroll Run
3940: pay_assignment_actions act1, --Prepayments

Line 3937: pay_payroll_actions appa, --Payroll Run

3933:
3934: SELECT count(distinct act.assignment_action_id),
3935: max(act.assignment_action_id) assignment_action_id
3936: FROM pay_payroll_actions ppa, --Current pactid
3937: pay_payroll_actions appa, --Payroll Run
3938: pay_payroll_actions appa2, --Prepayments
3939: pay_assignment_actions act, --Payroll Run
3940: pay_assignment_actions act1, --Prepayments
3941: pay_action_interlocks pai, --Prepayments

Line 3938: pay_payroll_actions appa2, --Prepayments

3934: SELECT count(distinct act.assignment_action_id),
3935: max(act.assignment_action_id) assignment_action_id
3936: FROM pay_payroll_actions ppa, --Current pactid
3937: pay_payroll_actions appa, --Payroll Run
3938: pay_payroll_actions appa2, --Prepayments
3939: pay_assignment_actions act, --Payroll Run
3940: pay_assignment_actions act1, --Prepayments
3941: pay_action_interlocks pai, --Prepayments
3942: per_all_assignments_f as1

Line 3967: pay_payroll_actions pact,

3963: || paa.assignment_action_id),16)) max_asg_act_id,
3964: MAX(pact.effective_date) effective_date
3965: FROM pay_assignment_actions paa,
3966: per_all_assignments_f paaf,
3967: pay_payroll_actions pact,
3968: per_time_periods ptp
3969: WHERE paa.assignment_id = paaf.assignment_id
3970: AND paaf.person_id = c_person_id --41650
3971: AND paa.payroll_action_id = pact.payroll_action_id

Line 4474: FROM pay_payroll_actions pact

4470: l_error_flag VARCHAR2(1);
4471: CURSOR csr_is_etext_report
4472: IS
4473: SELECT report_type
4474: FROM pay_payroll_actions pact
4475: WHERE pact.payroll_action_id = pactid;
4476: l_is_etext_report VARCHAR2(50);
4477: l_request_id fnd_concurrent_requests.request_id%TYPE;
4478: xml_layout BOOLEAN;

Line 4499: FROM pay_payroll_actions pact,

4495: hoi.org_information7 econ_number,
4496: pact.business_group_id bus_grp_id,
4497: pact.action_parameter_group_id act_param_grp_id,
4498: org_information19 service_company
4499: FROM pay_payroll_actions pact,
4500: hr_organization_information hoi
4501: WHERE pact.payroll_action_id =pactid
4502: AND pact.business_group_id = hoi.organization_id
4503: AND hoi.org_information_context = 'Tax Details References'

Line 4538: FROM pay_payroll_actions pact

4534: SELECT legislative_parameters para,
4535: fnd_number.number_to_canonical(request_id) control_id,
4536: report_type,
4537: business_group_id
4538: FROM pay_payroll_actions pact
4539: WHERE payroll_action_id = pactid;
4540:
4541: CURSOR csr_header_det(p_bus_id NUMBER, p_tax_ref VARCHAR2)
4542: IS

Line 4556: from pay_payrolls_f ppf,pay_payroll_actions ppapre,pay_payroll_actions ppa

4552:
4553: CURSOR csr_payroll_details
4554: IS
4555: SELECT ppf.PAYROLL_NAME , ppapre.EFFECTIVE_DATE
4556: from pay_payrolls_f ppf,pay_payroll_actions ppapre,pay_payroll_actions ppa
4557: WHERE ppa.payroll_action_id = pactid
4558: and ppf.payroll_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PAYROLL_ID'),1,20)
4559: and ppapre.payroll_action_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PRE_PAY_ID'),1,20);
4560:

Line 4566: FROM pay_payroll_actions ppa,

4562: CURSOR get_asg_action_id_error
4563: IS
4564: SELECT DISTINCT paa.assignment_action_id asg_action_id,
4565: assignment_id
4566: FROM pay_payroll_actions ppa,
4567: pay_assignment_actions paa
4568: WHERE ppa.payroll_action_id = pactid -- pact_id
4569: AND paa.payroll_action_id = ppa.payroll_action_id
4570: AND paa.action_status = 'E';

Line 4703: FROM pay_payroll_actions ppa,

4699: CURSOR get_asg_action_id
4700: IS
4701: SELECT DISTINCT paa.assignment_action_id asg_action_id,
4702: assignment_id
4703: FROM pay_payroll_actions ppa,
4704: pay_assignment_actions paa
4705: WHERE ppa.payroll_action_id = pactid -- pact_id
4706: AND paa.payroll_action_id = ppa.payroll_action_id
4707: AND paa.action_status = 'C';

Line 4714: FROM pay_payroll_actions ppa,

4710: CURSOR get_asg_action_id_error
4711: IS
4712: SELECT DISTINCT paa.assignment_action_id asg_action_id,
4713: assignment_id
4714: FROM pay_payroll_actions ppa,
4715: pay_assignment_actions paa
4716: WHERE ppa.payroll_action_id = pactid -- pact_id
4717: AND paa.payroll_action_id = ppa.payroll_action_id
4718: AND paa.action_status = 'E';

Line 4775: from pay_payroll_actions

4771: AND payroll_id = 100;
4772:
4773: cursor csr_get_eff_date(p_pact_id number) is
4774: select EFFECTIVE_DATE
4775: from pay_payroll_actions
4776: where payroll_action_id = p_pact_id;
4777:
4778: err_msg varchar2(255);--csr_err_msg%rowtype;
4779: et_asg_rec get_person_details%rowtype;

Line 4901: FROM pay_payroll_actions ppa,

4897:
4898: CURSOR get_person_count
4899: IS
4900: SELECT COUNT(DISTINCT(paaf.person_id))
4901: FROM pay_payroll_actions ppa,
4902: pay_assignment_actions paa,
4903: per_all_assignments_f paaf
4904: WHERE ppa.payroll_action_id = pactid -- pact_id
4905: AND paa.payroll_action_id = ppa.payroll_action_id