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_ASSIGNMENT_ACTIONS

Line 571: FROM pay_assignment_actions

567:
568: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
569: IS
570: SELECT MAX(ASSIGNMENT_ACTION_ID)
571: FROM pay_assignment_actions
572: WHERE SOURCE_ACTION_ID = c_lst_act_id;
573:
574: CURSOR csr_tax_paye_result(p_action_id NUMBER)
575: IS

Line 646: pay_assignment_actions paa,

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
650: AND ppa.payroll_id = ptp.payroll_id

Line 699: pay_assignment_actions paa,

695: trim(NVL(pap.per_information10,'N')) per_paye_agg_flag,
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

Line 717: FROM pay_assignment_actions paa,

713: /*+ USE_NL(paa, pact, ptp) */
714: to_number(SUBSTR(MAX(lpad(paa.action_sequence,15,'0')
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

Line 731: from pay_assignment_actions paa,

727: AND ptp.regular_payment_date BETWEEN p_start_date AND p_end_date;
728:
729: cursor csr_agg_oldest_asg is
730: select paa.assignment_action_id, paa.assignment_id
731: from pay_assignment_actions paa,
732: per_all_assignments_f paaf
733: where paaf.person_id = p_person_id
734: and paaf.assignment_id = paa.assignment_id
735: and paa.payroll_action_id = p_pactid

Line 738: from pay_assignment_actions paa1,

734: and paaf.assignment_id = paa.assignment_id
735: and paa.payroll_action_id = p_pactid
736: and paaf.effective_start_date =
737: (select min(paaf1.effective_start_date)
738: from pay_assignment_actions paa1,
739: per_all_assignments_f paaf1
740: where paaf1.person_id = p_person_id
741: and paaf1.assignment_id = paa1.assignment_id
742: and paa1.payroll_action_id = p_pactid

Line 747: from pay_assignment_actions paa,

743: );
744:
745: cursor csr_agg_primary_asg is
746: select paa.assignment_id
747: from pay_assignment_actions paa,
748: per_all_assignments_f paaf,
749: per_all_people_f papf
750: where paaf.person_id = p_person_id --41650 --
751: and paaf.assignment_id = paa.assignment_id

Line 2064: FROM pay_assignment_actions

2060:
2061: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
2062: IS
2063: SELECT ASSIGNMENT_ACTION_ID
2064: FROM pay_assignment_actions
2065: WHERE SOURCE_ACTION_ID = c_lst_act_id;
2066:
2067:
2068: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)

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 2525: FROM pay_assignment_actions

2521:
2522: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
2523: IS
2524: SELECT ASSIGNMENT_ACTION_ID
2525: FROM pay_assignment_actions
2526: WHERE SOURCE_ACTION_ID = c_lst_act_id;
2527: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2528: IS
2529: SELECT pdb.defined_balance_id

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 2792: FROM pay_assignment_actions

2788:
2789: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
2790: IS
2791: SELECT ASSIGNMENT_ACTION_ID
2792: FROM pay_assignment_actions
2793: WHERE SOURCE_ACTION_ID = c_lst_act_id;
2794: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2795: IS
2796: SELECT pdb.defined_balance_id

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 3350: FROM pay_assignment_actions paa

3346: to_number (substr (max (lpad (paa.action_sequence, 15
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

Line 3371: FROM pay_assignment_actions

3367: -- new agg changes
3368: CURSOR csr_asg_id(c_aggr_max_act_id number)
3369: IS
3370: SELECT assignment_id
3371: FROM pay_assignment_actions
3372: WHERE assignment_action_id = c_aggr_max_act_id;
3373:
3374: -- Declarations for First FPS
3375: l_last_asg_action_id number;

Line 3562: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;

3558: l_flag:= 'N';
3559: END IF;
3560:
3561: if l_flag = 'Y' Then --and l_first_fps_prepay_asg = 'N' Then
3562: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
3563: -- Insert assignment into pay_assignment_actions
3564: hr_nonrun_asact.insact(lockingactid, asg_record.assignment_id, pactid, chunk, NULL);
3565: hr_nonrun_asact.insint(lockingactid, l_last_asg_action_id);
3566: End if;

Line 3563: -- Insert assignment into pay_assignment_actions

3559: END IF;
3560:
3561: if l_flag = 'Y' Then --and l_first_fps_prepay_asg = 'N' Then
3562: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
3563: -- Insert assignment into pay_assignment_actions
3564: hr_nonrun_asact.insact(lockingactid, asg_record.assignment_id, pactid, chunk, NULL);
3565: hr_nonrun_asact.insint(lockingactid, l_last_asg_action_id);
3566: End if;
3567:

Line 3841: pay_assignment_actions paa,

3837: asg.person_id,
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

Line 3863: pay_assignment_actions paa

3859: trim(NVL(pap.per_information10,'N')) per_paye_agg_flag,
3860: asg.payroll_id payroll_id
3861: FROM per_all_people_f pap,
3862: per_all_assignments_f asg,
3863: pay_assignment_actions paa
3864: WHERE paa.assignment_action_id = c_asg_act_id
3865: AND paa.assignment_id = asg.assignment_id
3866: AND pap.person_id = asg.person_id
3867: -- and asg.business_group_id = l_business_group_id

Line 3881: FROM pay_assignment_actions paa

3877: to_number (substr (max (lpad (paa.action_sequence, 15
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

Line 3905: pay_assignment_actions paa

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:
3909: -- cursor to get assignment id using assignment action id parameter

Line 3912: FROM pay_assignment_actions paa

3908:
3909: -- cursor to get assignment id using assignment action id parameter
3910: CURSOR csr_asg_id(c_asg_act_id NUMBER) IS
3911: SELECT paa.assignment_id
3912: FROM pay_assignment_actions paa
3913: WHERE paa.assignment_action_id = c_asg_act_id;
3914:
3915: -- Cursor to fetch the RTI NI Reporting assignment for this person.
3916: cursor csr_get_ni_rpt_asg(c_asg_id number) is

Line 3939: pay_assignment_actions act, --Payroll Run

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
3943: WHERE as1.person_id = p_person_id --45885

Line 3940: pay_assignment_actions act1, --Prepayments

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
3943: WHERE as1.person_id = p_person_id --45885
3944: AND appa.action_type IN ('R','Q') -- Payroll Run or Quickpay Run

Line 3965: FROM pay_assignment_actions paa,

3961: /*+ USE_NL(paa, pact, ptp) */
3962: to_number(SUBSTR(MAX(lpad(paa.action_sequence,15,'0')
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

Line 3982: pay_assignment_actions paa

3978: CURSOR csr_asg_num(c_asg_act_id NUMBER, c_cur_last_effective_date date)
3979: IS
3980: SELECT asg.assignment_number
3981: FROM per_all_assignments_f asg,
3982: pay_assignment_actions paa
3983: WHERE paa.assignment_action_id = c_asg_act_id
3984: AND paa.assignment_id = asg.assignment_id
3985: AND c_cur_last_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
3986:

Line 4567: pay_assignment_actions paa

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';
4571:

Line 4704: pay_assignment_actions paa

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';
4708:

Line 4715: pay_assignment_actions paa

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';
4719:

Line 4902: pay_assignment_actions paa,

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
4906: AND paa.action_status = 'C'