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

Line 1943: FROM pay_payroll_actions ppa,

1939: IS
1940: SELECT ptp.regular_payment_date,
1941: ptp.period_num,
1942: ptp.period_type
1943: FROM pay_payroll_actions ppa,
1944: pay_assignment_actions paa,
1945: per_time_periods ptp
1946: WHERE assignment_action_id = p_last_asg_action_id
1947: AND ppa.time_period_id = ptp.time_period_id

Line 2043: pay_payroll_actions pact,

2039: /*+ USE_NL(paa, pact, ptp) */
2040: MIN(ptp.start_date) payroll_period_start_date,
2041: MAX(ptp.end_date) payroll_period_end_date
2042: FROM pay_assignment_actions paa,
2043: pay_payroll_actions pact,
2044: per_time_periods ptp,
2045: pay_assignment_actions paa1, --Prepayments
2046: pay_payroll_actions ppa1, --Prepayments
2047: pay_action_interlocks pai --Prepayments

Line 2046: pay_payroll_actions ppa1, --Prepayments

2042: FROM pay_assignment_actions paa,
2043: pay_payroll_actions pact,
2044: per_time_periods ptp,
2045: pay_assignment_actions paa1, --Prepayments
2046: pay_payroll_actions ppa1, --Prepayments
2047: pay_action_interlocks pai --Prepayments
2048: WHERE paa.assignment_id = p_asgid
2049: AND paa.payroll_action_id = pact.payroll_action_id
2050: AND pact.time_period_id = ptp.time_period_id

Line 2086: from pay_payroll_actions ppa_prev,

2082: --Below cursor fetches the Last Pre-Payment id
2083: CURSOR csr_last_pre_pay_id (c_asg_id NUMBER)
2084: IS
2085: select ppa_prev.payroll_action_id
2086: from pay_payroll_actions ppa_prev,
2087: pay_payroll_actions ppa_current
2088: where ppa_prev.action_type IN ('P','U')
2089: and ppa_prev.payroll_id = ppa_current.payroll_id
2090: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id

Line 2087: pay_payroll_actions ppa_current

2083: CURSOR csr_last_pre_pay_id (c_asg_id NUMBER)
2084: IS
2085: select ppa_prev.payroll_action_id
2086: from pay_payroll_actions ppa_prev,
2087: pay_payroll_actions ppa_current
2088: where ppa_prev.action_type IN ('P','U')
2089: and ppa_prev.payroll_id = ppa_current.payroll_id
2090: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id
2091: and ppa_current.payroll_action_id = g_pre_pact_id

Line 2094: from pay_payroll_actions ppa_max,

2090: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id
2091: and ppa_current.payroll_action_id = g_pre_pact_id
2092: and ppa_prev.payroll_action_id =
2093: (select max(ppa_max.payroll_action_id)
2094: from pay_payroll_actions ppa_max,
2095: pay_assignment_actions paa_max
2096: where ppa_max.payroll_id = ppa_current.payroll_id
2097: and ppa_max.payroll_action_id < ppa_current.payroll_action_id
2098: and ppa_max.action_type IN ('P','U')

Line 2107: pay_payroll_actions ppa_prepay,

2103: CURSOR csr_last_fps_asg_act_id (c_last_pre_pay_id NUMBER, c_asg_id NUMBER)
2104: IS
2105: select paa_fps.assignment_action_id
2106: from pay_assignment_actions paa_prepay,
2107: pay_payroll_actions ppa_prepay,
2108: pay_assignment_actions paa_fps,
2109: pay_payroll_actions ppa_fps,
2110: pay_action_interlocks pai
2111: where ppa_prepay.payroll_action_id = c_last_pre_pay_id

Line 2109: pay_payroll_actions ppa_fps,

2105: select paa_fps.assignment_action_id
2106: from pay_assignment_actions paa_prepay,
2107: pay_payroll_actions ppa_prepay,
2108: pay_assignment_actions paa_fps,
2109: pay_payroll_actions ppa_fps,
2110: pay_action_interlocks pai
2111: where ppa_prepay.payroll_action_id = c_last_pre_pay_id
2112: and ppa_prepay.payroll_action_id = paa_prepay.payroll_action_id
2113: and paa_prepay.assignment_action_id = pai.locked_action_id

Line 2729: FROM pay_payroll_actions ppa,

2725: IS
2726: SELECT ptp.regular_payment_date,
2727: ptp.period_num,
2728: ptp.period_type
2729: FROM pay_payroll_actions ppa,
2730: pay_assignment_actions paa,
2731: per_time_periods ptp
2732: WHERE assignment_action_id = l_last_asg_action_id
2733: AND ppa.time_period_id = ptp.time_period_id

Line 2819: pay_payroll_actions pact,

2815: /*+ USE_NL(paa, pact, ptp) */
2816: MIN(ptp.start_date) payroll_period_start_date,
2817: MAX(ptp.end_date) payroll_period_end_date
2818: FROM pay_assignment_actions paa,
2819: pay_payroll_actions pact,
2820: per_time_periods ptp,
2821: pay_assignment_actions paa1, --Prepayments
2822: pay_payroll_actions ppa1, --Prepayments
2823: pay_action_interlocks pai --Prepayments

Line 2822: pay_payroll_actions ppa1, --Prepayments

2818: FROM pay_assignment_actions paa,
2819: pay_payroll_actions pact,
2820: per_time_periods ptp,
2821: pay_assignment_actions paa1, --Prepayments
2822: pay_payroll_actions ppa1, --Prepayments
2823: pay_action_interlocks pai --Prepayments
2824: WHERE paa.assignment_id = p_asgid
2825: AND paa.payroll_action_id = pact.payroll_action_id
2826: AND pact.time_period_id = ptp.time_period_id

Line 2862: from pay_payroll_actions ppa_prev,

2858: --Below cursor fetches the Last Pre-Payment id
2859: CURSOR csr_last_pre_pay_id (c_asg_id NUMBER)
2860: IS
2861: select ppa_prev.payroll_action_id
2862: from pay_payroll_actions ppa_prev,
2863: pay_payroll_actions ppa_current
2864: where ppa_prev.action_type IN ('P','U')
2865: and ppa_prev.payroll_id = ppa_current.payroll_id
2866: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id

Line 2863: pay_payroll_actions ppa_current

2859: CURSOR csr_last_pre_pay_id (c_asg_id NUMBER)
2860: IS
2861: select ppa_prev.payroll_action_id
2862: from pay_payroll_actions ppa_prev,
2863: pay_payroll_actions ppa_current
2864: where ppa_prev.action_type IN ('P','U')
2865: and ppa_prev.payroll_id = ppa_current.payroll_id
2866: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id
2867: and ppa_current.payroll_action_id = g_pre_pact_id

Line 2870: from pay_payroll_actions ppa_max,

2866: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id
2867: and ppa_current.payroll_action_id = g_pre_pact_id
2868: and ppa_prev.payroll_action_id =
2869: (select max(ppa_max.payroll_action_id)
2870: from pay_payroll_actions ppa_max,
2871: pay_assignment_actions paa_max
2872: where ppa_max.payroll_id = ppa_current.payroll_id
2873: and ppa_max.payroll_action_id < ppa_current.payroll_action_id
2874: and ppa_max.action_type IN ('P','U')

Line 2883: pay_payroll_actions ppa_prepay,

2879: CURSOR csr_last_fps_asg_act_id (c_last_pre_pay_id NUMBER, c_asg_id NUMBER)
2880: IS
2881: select paa_fps.assignment_action_id
2882: from pay_assignment_actions paa_prepay,
2883: pay_payroll_actions ppa_prepay,
2884: pay_assignment_actions paa_fps,
2885: pay_payroll_actions ppa_fps,
2886: pay_action_interlocks pai
2887: where ppa_prepay.payroll_action_id = c_last_pre_pay_id

Line 2885: pay_payroll_actions ppa_fps,

2881: select paa_fps.assignment_action_id
2882: from pay_assignment_actions paa_prepay,
2883: pay_payroll_actions ppa_prepay,
2884: pay_assignment_actions paa_fps,
2885: pay_payroll_actions ppa_fps,
2886: pay_action_interlocks pai
2887: where ppa_prepay.payroll_action_id = c_last_pre_pay_id
2888: and ppa_prepay.payroll_action_id = paa_prepay.payroll_action_id
2889: and paa_prepay.assignment_action_id = pai.locked_action_id

Line 2930: pay_payroll_actions pact,

2926: || paa.assignment_action_id),16)) max_asg_act_id,
2927: MAX(pact.effective_date) effective_date
2928: FROM per_all_assignments_f paaf,
2929: pay_assignment_actions paa,
2930: pay_payroll_actions pact,
2931: per_time_periods ptp,
2932: pay_assignment_actions paa1, --Prepayments
2933: pay_payroll_actions ppa1, --Prepayments
2934: pay_action_interlocks pai --Prepayments

Line 2933: pay_payroll_actions ppa1, --Prepayments

2929: pay_assignment_actions paa,
2930: pay_payroll_actions pact,
2931: per_time_periods ptp,
2932: pay_assignment_actions paa1, --Prepayments
2933: pay_payroll_actions ppa1, --Prepayments
2934: pay_action_interlocks pai --Prepayments
2935: WHERE paaf.person_id = p_person_rec.person_id--59437
2936: AND sysdate between paaf.effective_start_date and paaf.effective_end_date
2937: AND paa.assignment_id = paaf.assignment_id

Line 3531: FROM pay_payroll_actions ppa,

3527: IS
3528: SELECT ptp.regular_payment_date,
3529: ptp.period_num,
3530: ptp.period_type
3531: FROM pay_payroll_actions ppa,
3532: pay_assignment_actions paa,
3533: per_time_periods ptp
3534: WHERE assignment_action_id = p_last_asg_action_id
3535: AND ppa.time_period_id = ptp.time_period_id

Line 3622: pay_payroll_actions pact,

3618: /*+ USE_NL(paa, pact, ptp) */
3619: MIN(ptp.start_date) payroll_period_start_date,
3620: MAX(ptp.end_date) payroll_period_end_date
3621: FROM pay_assignment_actions paa,
3622: pay_payroll_actions pact,
3623: per_time_periods ptp,
3624: pay_assignment_actions paa1, --Prepayments
3625: pay_payroll_actions ppa1, --Prepayments
3626: pay_action_interlocks pai --Prepayments

Line 3625: pay_payroll_actions ppa1, --Prepayments

3621: FROM pay_assignment_actions paa,
3622: pay_payroll_actions pact,
3623: per_time_periods ptp,
3624: pay_assignment_actions paa1, --Prepayments
3625: pay_payroll_actions ppa1, --Prepayments
3626: pay_action_interlocks pai --Prepayments
3627: WHERE paa.assignment_id = p_asgid
3628: AND paa.payroll_action_id = pact.payroll_action_id
3629: AND pact.time_period_id = ptp.time_period_id

Line 3665: from pay_payroll_actions ppa_prev,

3661: --Below cursor fetches the Last Pre-Payment id
3662: CURSOR csr_last_pre_pay_id (c_asg_id NUMBER)
3663: IS
3664: select ppa_prev.payroll_action_id
3665: from pay_payroll_actions ppa_prev,
3666: pay_payroll_actions ppa_current
3667: where ppa_prev.action_type IN ('P','U')
3668: and ppa_prev.payroll_id = ppa_current.payroll_id
3669: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id

Line 3666: pay_payroll_actions ppa_current

3662: CURSOR csr_last_pre_pay_id (c_asg_id NUMBER)
3663: IS
3664: select ppa_prev.payroll_action_id
3665: from pay_payroll_actions ppa_prev,
3666: pay_payroll_actions ppa_current
3667: where ppa_prev.action_type IN ('P','U')
3668: and ppa_prev.payroll_id = ppa_current.payroll_id
3669: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id
3670: and ppa_current.payroll_action_id = g_pre_pact_id

Line 3673: from pay_payroll_actions ppa_max,

3669: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id
3670: and ppa_current.payroll_action_id = g_pre_pact_id
3671: and ppa_prev.payroll_action_id =
3672: (select max(ppa_max.payroll_action_id)
3673: from pay_payroll_actions ppa_max,
3674: pay_assignment_actions paa_max
3675: where ppa_max.payroll_id = ppa_current.payroll_id
3676: and ppa_max.payroll_action_id < ppa_current.payroll_action_id
3677: and ppa_max.action_type IN ('P','U')

Line 3686: pay_payroll_actions ppa_prepay,

3682: CURSOR csr_last_fps_asg_act_id (c_last_pre_pay_id NUMBER, c_asg_id NUMBER)
3683: IS
3684: select paa_fps.assignment_action_id
3685: from pay_assignment_actions paa_prepay,
3686: pay_payroll_actions ppa_prepay,
3687: pay_assignment_actions paa_fps,
3688: pay_payroll_actions ppa_fps,
3689: pay_action_interlocks pai
3690: where ppa_prepay.payroll_action_id = c_last_pre_pay_id

Line 3688: pay_payroll_actions ppa_fps,

3684: select paa_fps.assignment_action_id
3685: from pay_assignment_actions paa_prepay,
3686: pay_payroll_actions ppa_prepay,
3687: pay_assignment_actions paa_fps,
3688: pay_payroll_actions ppa_fps,
3689: pay_action_interlocks pai
3690: where ppa_prepay.payroll_action_id = c_last_pre_pay_id
3691: and ppa_prepay.payroll_action_id = paa_prepay.payroll_action_id
3692: and paa_prepay.assignment_action_id = pai.locked_action_id

Line 6652: FROM pay_payroll_actions

6648: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date,
6649: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIN_SUB'),1,20) final_submission,
6650: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'DATE_SCHEME'),1,10)) final_submission,
6651: effective_date
6652: FROM pay_payroll_actions
6653: WHERE payroll_action_id = pactid;
6654:
6655: CURSOR csr_get_payroll_id(c_pre_pact_id NUMBER)
6656: IS

Line 6658: FROM pay_payroll_actions

6654:
6655: CURSOR csr_get_payroll_id(c_pre_pact_id NUMBER)
6656: IS
6657: SELECT payroll_id
6658: FROM pay_payroll_actions
6659: WHERE payroll_action_id = c_pre_pact_id;
6660:
6661: -- cursor to check whether first fps is run for this payroll or not
6662: cursor c_first_fps_ran(c_payroll_id number) is

Line 6663: select 'Y' from pay_payroll_actions ppa

6659: WHERE payroll_action_id = c_pre_pact_id;
6660:
6661: -- cursor to check whether first fps is run for this payroll or not
6662: cursor c_first_fps_ran(c_payroll_id number) is
6663: select 'Y' from pay_payroll_actions ppa
6664: where c_payroll_id = pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYROLL_ID')
6665: and pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS') = 'Y'
6666: and ACTION_STATUS = 'C'
6667: and exists (select 1 from pay_gb_fps_details where PAYROLL_ACTION_ID = ppa.payroll_action_id);

Line 6671: from pay_payroll_actions ppa

6667: and exists (select 1 from pay_gb_fps_details where PAYROLL_ACTION_ID = ppa.payroll_action_id);
6668:
6669: cursor csr_other_prepay_pactid(c_tax_ref varchar2) is
6670: select distinct ppa.payroll_action_id
6671: from pay_payroll_actions ppa
6672: where ppa.effective_date >= sysdate - 30
6673: and ppa.action_type in ('P','U')
6674: and ppa.action_status ='C'
6675: and ppa.payroll_id in (select distinct payroll_id

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

6781: RAISE date_scheme_error;
6782: end if;
6783:
6784: sqlstr := 'select distinct PERSON_ID '|| 'from per_all_assignments_f paaf, '
6785: || 'pay_payroll_actions ppa '|| 'where ppa.payroll_action_id = :payroll_action_id '
6786: || 'and ppa.business_group_id = paaf.business_group_id '|| ' and paaf.payroll_id = '
6787: ||''''||l_payroll_id||''''|| ' order by person_id';
6788:
6789: hr_utility.trace(' Range Cursor Statement : '||sqlstr);

Line 6841: FROM pay_payroll_actions pact

6837: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS'),1,1) first_fps,
6838: effective_date,
6839: business_group_id,
6840: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date
6841: FROM pay_payroll_actions pact
6842: WHERE payroll_action_id = pactid;
6843:
6844: CURSOR csr_asg(c_asg_id NUMBER, c_effective_date DATE)
6845: IS

Line 6868: FROM pay_payroll_actions ppa, --Current pactid

6864: c_effective_date DATE)
6865: IS
6866: SELECT DISTINCT act.assignment_id assignment_id,
6867: act.assignment_action_id asg_act_id
6868: FROM pay_payroll_actions ppa, --Current pactid
6869: pay_payroll_actions appa, --Payroll Run
6870: pay_payroll_actions appa2, --Prepayments
6871: pay_assignment_actions act, --Payroll Run
6872: pay_assignment_actions act1, --Prepayments

Line 6869: pay_payroll_actions appa, --Payroll Run

6865: IS
6866: SELECT DISTINCT act.assignment_id assignment_id,
6867: act.assignment_action_id asg_act_id
6868: FROM pay_payroll_actions ppa, --Current pactid
6869: pay_payroll_actions appa, --Payroll Run
6870: pay_payroll_actions appa2, --Prepayments
6871: pay_assignment_actions act, --Payroll Run
6872: pay_assignment_actions act1, --Prepayments
6873: pay_action_interlocks pai, --Prepayments

Line 6870: pay_payroll_actions appa2, --Prepayments

6866: SELECT DISTINCT act.assignment_id assignment_id,
6867: act.assignment_action_id asg_act_id
6868: FROM pay_payroll_actions ppa, --Current pactid
6869: pay_payroll_actions appa, --Payroll Run
6870: pay_payroll_actions appa2, --Prepayments
6871: pay_assignment_actions act, --Payroll Run
6872: pay_assignment_actions act1, --Prepayments
6873: pay_action_interlocks pai, --Prepayments
6874: per_all_assignments_f as1

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

6905:
6906:
6907: -- First FPS Cursors
6908: cursor csr_get_prepayment_date(p_pre_pact_id number) is
6909: select EFFECTIVE_DATE from pay_payroll_actions where payroll_action_id = p_pre_pact_id;
6910:
6911: cursor csr_asg_details(p_prepay_id number,p_prepayment_date date) is
6912: select distinct paaf.assignment_id assignment_id,
6913: trim(paaf.primary_flag) asg_primary_flag,

Line 6919: pay_payroll_actions paa

6915: pap.person_id
6916: from per_all_people_f pap,
6917: per_all_assignments_f paaf,
6918: per_assignment_status_types past,
6919: pay_payroll_actions paa
6920: where pap.person_id between stperson and endperson
6921: and paa.payroll_Action_id = p_prepay_id
6922: and pap.person_id = paaf.person_id
6923: and paaf.assignment_type = 'E'

Line 6974: , pay_payroll_actions pact

6970: , '0')
6971: || paa.assignment_action_id), 16))
6972: , max (pact.effective_date) effective_date
6973: FROM pay_assignment_actions paa
6974: , pay_payroll_actions pact
6975: , per_time_periods ptp
6976: WHERE paa.assignment_id = p_asgid
6977: AND paa.payroll_action_id = pact.payroll_action_id
6978: AND pact.payroll_id = l_payroll_id

Line 6996: FROM pay_payroll_actions ppa, --Current pactid

6992:
6993: SELECT max (act.assignment_action_id) assignment_id
6994: -- SELECT min (act.assignment_action_id) assignment_id
6995: -- SELECT max (act.assignment_id) assignment_id
6996: FROM pay_payroll_actions ppa, --Current pactid
6997: pay_payroll_actions appa, --Payroll Run
6998: pay_payroll_actions appa2, --Prepayments
6999: pay_assignment_actions act, --Payroll Run
7000: pay_assignment_actions act1, --Prepayments

Line 6997: pay_payroll_actions appa, --Payroll Run

6993: SELECT max (act.assignment_action_id) assignment_id
6994: -- SELECT min (act.assignment_action_id) assignment_id
6995: -- SELECT max (act.assignment_id) assignment_id
6996: FROM pay_payroll_actions ppa, --Current pactid
6997: pay_payroll_actions appa, --Payroll Run
6998: pay_payroll_actions appa2, --Prepayments
6999: pay_assignment_actions act, --Payroll Run
7000: pay_assignment_actions act1, --Prepayments
7001: pay_action_interlocks pai, --Prepayments

Line 6998: pay_payroll_actions appa2, --Prepayments

6994: -- SELECT min (act.assignment_action_id) assignment_id
6995: -- SELECT max (act.assignment_id) assignment_id
6996: FROM pay_payroll_actions ppa, --Current pactid
6997: pay_payroll_actions appa, --Payroll Run
6998: pay_payroll_actions appa2, --Prepayments
6999: pay_assignment_actions act, --Payroll Run
7000: pay_assignment_actions act1, --Prepayments
7001: pay_action_interlocks pai, --Prepayments
7002: per_all_assignments_f as1

Line 7031: FROM pay_payroll_actions ppa, --Current pactid

7027: IS
7028:
7029: SELECT max (act.assignment_action_id) assignment_id
7030: -- SELECT max (act.assignment_id) assignment_id
7031: FROM pay_payroll_actions ppa, --Current pactid
7032: pay_payroll_actions appa, --Payroll Run
7033: pay_payroll_actions appa2, --Prepayments
7034: pay_assignment_actions act, --Payroll Run
7035: pay_assignment_actions act1, --Prepayments

Line 7032: pay_payroll_actions appa, --Payroll Run

7028:
7029: SELECT max (act.assignment_action_id) assignment_id
7030: -- SELECT max (act.assignment_id) assignment_id
7031: FROM pay_payroll_actions ppa, --Current pactid
7032: pay_payroll_actions appa, --Payroll Run
7033: pay_payroll_actions appa2, --Prepayments
7034: pay_assignment_actions act, --Payroll Run
7035: pay_assignment_actions act1, --Prepayments
7036: pay_action_interlocks pai, --Prepayments

Line 7033: pay_payroll_actions appa2, --Prepayments

7029: SELECT max (act.assignment_action_id) assignment_id
7030: -- SELECT max (act.assignment_id) assignment_id
7031: FROM pay_payroll_actions ppa, --Current pactid
7032: pay_payroll_actions appa, --Payroll Run
7033: pay_payroll_actions appa2, --Prepayments
7034: pay_assignment_actions act, --Payroll Run
7035: pay_assignment_actions act1, --Prepayments
7036: pay_action_interlocks pai, --Prepayments
7037: per_all_assignments_f as1

Line 7077: ,pay_payroll_actions pact

7073: ,max(paa1.assignment_action_id)*/
7074: FROM pay_assignment_actions paa
7075: ,pay_assignment_actions paa1
7076: ,per_all_assignments_f paaf
7077: ,pay_payroll_actions pact
7078: ,pay_payroll_actions pact1
7079: ,per_time_periods ptp
7080: ,pay_action_interlocks pai
7081: WHERE paa.assignment_id = paaf.assignment_id

Line 7078: ,pay_payroll_actions pact1

7074: FROM pay_assignment_actions paa
7075: ,pay_assignment_actions paa1
7076: ,per_all_assignments_f paaf
7077: ,pay_payroll_actions pact
7078: ,pay_payroll_actions pact1
7079: ,per_time_periods ptp
7080: ,pay_action_interlocks pai
7081: WHERE paa.assignment_id = paaf.assignment_id
7082: AND paa.assignment_id <> p_asg_id

Line 7135: ,pay_payroll_actions pact

7131: distinct max(paa1.assignment_action_id) max_pre_act_id
7132: FROM pay_assignment_actions paa
7133: ,pay_assignment_actions paa1
7134: ,per_all_assignments_f paaf
7135: ,pay_payroll_actions pact
7136: ,pay_payroll_actions pact1
7137: ,per_time_periods ptp
7138: ,pay_action_interlocks pai
7139: WHERE paa.assignment_id = paaf.assignment_id

Line 7136: ,pay_payroll_actions pact1

7132: FROM pay_assignment_actions paa
7133: ,pay_assignment_actions paa1
7134: ,per_all_assignments_f paaf
7135: ,pay_payroll_actions pact
7136: ,pay_payroll_actions pact1
7137: ,per_time_periods ptp
7138: ,pay_action_interlocks pai
7139: WHERE paa.assignment_id = paaf.assignment_id
7140: AND paa.assignment_id = p_asg_id

Line 7181: pay_payroll_actions ppa,

7177: cursor chk_processed_in_prepay(c_cur_asg_action_id number) is
7178: select pai.locking_action_id
7179: from
7180: pay_action_interlocks pai,
7181: pay_payroll_actions ppa,
7182: pay_assignment_actions paa
7183: where pai.locked_action_id = c_cur_asg_action_id
7184: and ppa.action_type in ('P','U')
7185: and paa.payroll_action_id = ppa.payroll_action_id

Line 7194: pay_payroll_actions ppa

7190: SELECT paa.assignment_action_id,
7191: ppa.payroll_action_id,
7192: ppa.effective_date
7193: FROM pay_assignment_actions paa,
7194: pay_payroll_actions ppa
7195: WHERE paa.assignment_id = p_asgid
7196: AND ppa.payroll_action_id = p_pre_pay_id
7197: AND paa.payroll_action_id = ppa.payroll_action_id;
7198:

Line 7202: FROM pay_payroll_actions ppa2

7198:
7199: CURSOR get_first_fps_date(c_payroll_id number)
7200: IS
7201: SELECT max (ppa2.effective_date)
7202: FROM pay_payroll_actions ppa2
7203: WHERE ppa2.report_qualifier = 'GB'
7204: AND ppa2.report_type in ('RTI_FPS_REP','RTI_FPS_REP_13')
7205: AND ppa2.action_status = 'C'
7206: AND substr (pay_gb_eoy_archive.get_parameter (ppa2.legislative_parameters,'FIRST_FPS'),1,20) = 'Y'

Line 7235: pay_payroll_actions ppa

7231: cursor csr_ni_prepay_asg_act_details(c_payroll_asg_act_id number) is
7232: select pai.locking_action_id prepay_asg_act_id from
7233: pay_action_interlocks pai,
7234: pay_assignment_actions paa,
7235: pay_payroll_actions ppa
7236: where pai.locked_action_id = c_payroll_asg_act_id
7237: and pai.locking_action_id = paa.assignment_action_id
7238: and paa.action_status in ('C','S')
7239: and ppa.action_type in ('P','U')

Line 7245: pay_payroll_actions ppa

7241:
7242: -- to check whether the given assignment is processed in given prepay payroll_action id
7243: cursor csr_rti_rpt_proc_prepay(c_ni_rpt_asg_id number,c_pre_pay_action_id number) is
7244: select 'Y' from pay_assignment_actions paa,
7245: pay_payroll_actions ppa
7246: where
7247: ppa.payroll_action_id = c_pre_pay_action_id
7248: and ppa.payroll_action_id = paa.payroll_action_id
7249: and paa.assignment_id = c_ni_rpt_asg_id

Line 7269: pay_payroll_actions pact,

7265: IS
7266: SELECT count(distinct paa1.assignment_id)
7267: FROM pay_assignment_actions paa,
7268: per_all_assignments_f paaf,
7269: pay_payroll_actions pact,
7270: per_time_periods ptp,
7271: pay_assignment_actions paa1, --Prepayments
7272: pay_payroll_actions ppa1, --Prepayments
7273: pay_action_interlocks pai --Prepayments

Line 7272: pay_payroll_actions ppa1, --Prepayments

7268: per_all_assignments_f paaf,
7269: pay_payroll_actions pact,
7270: per_time_periods ptp,
7271: pay_assignment_actions paa1, --Prepayments
7272: pay_payroll_actions ppa1, --Prepayments
7273: pay_action_interlocks pai --Prepayments
7274: WHERE paa.assignment_id = paaf.assignment_id
7275: AND paaf.person_id = p_person_id
7276: AND paa.payroll_action_id = pact.payroll_action_id

Line 7290: FROM pay_payroll_actions appa, --Payroll Run

7286:
7287: CURSOR csr_aggr_max_act_id( p_person_id NUMBER)
7288: IS
7289: SELECT max(act.assignment_action_id) assignment_action_id
7290: FROM pay_payroll_actions appa, --Payroll Run
7291: pay_payroll_actions appa2, --Prepayments
7292: pay_assignment_actions act, --Payroll Run
7293: pay_assignment_actions act1, --Prepayments
7294: pay_action_interlocks pai, --Prepayments

Line 7291: pay_payroll_actions appa2, --Prepayments

7287: CURSOR csr_aggr_max_act_id( p_person_id NUMBER)
7288: IS
7289: SELECT max(act.assignment_action_id) assignment_action_id
7290: FROM pay_payroll_actions appa, --Payroll Run
7291: pay_payroll_actions appa2, --Prepayments
7292: pay_assignment_actions act, --Payroll Run
7293: pay_assignment_actions act1, --Prepayments
7294: pay_action_interlocks pai, --Prepayments
7295: per_all_assignments_f as1,

Line 7912: FROM pay_payroll_actions

7908: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYROLL_ID'),1,20) payroll_id,
7909: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
7910: SUBSTR(pay_gb_eoy_archive.get_parameter (legislative_parameters, 'FIRST_FPS'), 1,1) first_fps
7911:
7912: FROM pay_payroll_actions
7913: WHERE payroll_action_id = p_payroll_action_id;
7914:
7915: cursor csr_prepayment_date(pre_pay_id number)
7916: is

Line 7920: pay_payroll_actions ppa

7916: is
7917: SELECT
7918: ppa.effective_date
7919: FROM
7920: pay_payroll_actions ppa
7921: WHERE
7922: ppa.payroll_action_id = pre_pay_id;
7923:
7924: CURSOR csr_pre_pact_eff_date(p_payroll_action_id NUMBER)

Line 7927: FROM pay_payroll_actions

7923:
7924: CURSOR csr_pre_pact_eff_date(p_payroll_action_id NUMBER)
7925: IS
7926: SELECT effective_date
7927: FROM pay_payroll_actions
7928: WHERE payroll_action_id = p_payroll_action_id;
7929:
7930: CURSOR csr_payroll_details(pactid NUMBER)
7931: IS

Line 7941: FROM pay_payroll_actions pact,

7937: lpad(NVL(SUBSTR(hoi.org_information1,1,3),' '),3,0) tax_office_no,
7938: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
7939: NVL(upper(SUBSTR(hoi.org_information6,1,13)),' ') acc_ref_no,
7940: report_type
7941: FROM pay_payroll_actions pact,
7942: hr_organization_information hoi
7943: WHERE pact.payroll_action_id =pactid
7944: AND pact.business_group_id = hoi.organization_id
7945: AND hoi.org_information_context = 'Tax Details References'

Line 8060: FROM pay_payroll_actions ppa2

8056:
8057: CURSOR get_first_fps_date(c_payroll_id number)
8058: IS
8059: SELECT max (ppa2.effective_date)
8060: FROM pay_payroll_actions ppa2
8061: WHERE ppa2.report_qualifier = 'GB'
8062: AND ppa2.report_type in ('RTI_FPS_REP','RTI_FPS_REP_13')
8063: AND ppa2.action_status = 'C'
8064: AND substr (pay_gb_eoy_archive.get_parameter (ppa2.legislative_parameters,'FIRST_FPS'),1,20) = 'Y'

Line 8585: ,pay_payroll_actions pact

8581: || paa.assignment_action_id),16)) max_asg_act_id
8582: , max(pact.effective_date) effective_date
8583:
8584: FROM pay_assignment_actions paa
8585: ,pay_payroll_actions pact
8586: ,per_time_periods ptp
8587: WHERE paa.assignment_id = c_asg_id
8588: AND paa.payroll_action_id = pact.payroll_action_id
8589: AND pact.time_period_id = ptp.time_period_id

Line 8604: ,pay_payroll_actions pact

8600: || paa.assignment_action_id),16)) max_asg_act_id
8601: , max(pact.effective_date) effective_date
8602:
8603: FROM pay_assignment_actions paa
8604: ,pay_payroll_actions pact
8605: ,per_time_periods ptp
8606: WHERE paa.assignment_id = c_asg_id
8607: AND paa.payroll_action_id = pact.payroll_action_id
8608: AND pact.time_period_id = ptp.time_period_id

Line 8770: FROM pay_payroll_actions ppa,

8766: --Below cursor fetches the payment date for the payroll run of the current assignment
8767: CURSOR csr_get_payment_date(p_last_asg_action_id NUMBER)
8768: IS
8769: SELECT ptp.regular_payment_date payment_date
8770: FROM pay_payroll_actions ppa,
8771: pay_assignment_actions paa,
8772: per_time_periods ptp
8773: WHERE assignment_action_id = p_last_asg_action_id
8774: AND ppa.time_period_id = ptp.time_period_id

Line 8801: pay_payroll_actions ppa

8797: asg.person_id,
8798: asg.assignment_number
8799: FROM per_all_assignments_f asg,
8800: pay_assignment_actions paa,
8801: pay_payroll_actions ppa
8802: WHERE paa.assignment_action_id = c_asg_act_id
8803: AND paa.assignment_id = asg.assignment_id
8804: AND ppa.payroll_action_id = g_pre_pact_id
8805: AND ppa.effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line 8837: pay_payroll_actions pact,

8833: to_number(SUBSTR(MAX(lpad(paa.action_sequence,15,'0')
8834: || paa.assignment_action_id),16)) max_asg_act_id,
8835: MAX(pact.effective_date) effective_date
8836: FROM pay_assignment_actions paa,
8837: pay_payroll_actions pact,
8838: per_time_periods ptp,
8839: pay_assignment_actions paa1, --Prepayments
8840: pay_payroll_actions ppa1, --Prepayments
8841: pay_action_interlocks pai --Prepayments

Line 8840: pay_payroll_actions ppa1, --Prepayments

8836: FROM pay_assignment_actions paa,
8837: pay_payroll_actions pact,
8838: per_time_periods ptp,
8839: pay_assignment_actions paa1, --Prepayments
8840: pay_payroll_actions ppa1, --Prepayments
8841: pay_action_interlocks pai --Prepayments
8842: WHERE paa.assignment_id = p_asgid
8843: AND paa.payroll_action_id = pact.payroll_action_id
8844: AND pact.time_period_id = ptp.time_period_id

Line 8863: pay_payroll_actions pact,

8859: to_number(SUBSTR(MAX(lpad(paa.action_sequence,15,'0')
8860: || paa.assignment_action_id),16)) max_asg_act_id,
8861: MAX(pact.effective_date) effective_date
8862: FROM pay_assignment_actions paa,
8863: pay_payroll_actions pact,
8864: per_time_periods ptp,
8865: pay_assignment_actions paa1, --Prepayments
8866: pay_payroll_actions ppa1, --Prepayments
8867: pay_action_interlocks pai --Prepayments

Line 8866: pay_payroll_actions ppa1, --Prepayments

8862: FROM pay_assignment_actions paa,
8863: pay_payroll_actions pact,
8864: per_time_periods ptp,
8865: pay_assignment_actions paa1, --Prepayments
8866: pay_payroll_actions ppa1, --Prepayments
8867: pay_action_interlocks pai --Prepayments
8868: WHERE paa.assignment_id = p_asgid --46959
8869: AND paa.payroll_action_id = pact.payroll_action_id
8870: AND pact.time_period_id = ptp.time_period_id

Line 8889: pay_payroll_actions ppa

8885: SELECT paa.assignment_action_id,
8886: ppa.payroll_action_id,
8887: ppa.effective_date
8888: FROM pay_assignment_actions paa,
8889: pay_payroll_actions ppa
8890: WHERE paa.assignment_id = p_asgid
8891: AND ppa.payroll_action_id = p_pre_pay_id
8892: AND paa.payroll_action_id = ppa.payroll_action_id;
8893: ---

Line 8968: pay_payroll_actions ppa

8964: pay_personal_payment_methods_f pppf,
8965: pay_external_accounts Orgkey,
8966: pay_external_accounts deskey,
8967: PAY_ASSIGNMENT_ACTIONS PAA,
8968: pay_payroll_actions ppa
8969: WHERE popf.ORG_PAYMENT_METHOD_ID = ppp.ORG_PAYMENT_METHOD_ID
8970: AND pppf.personal_payment_method_ID = ppp.personal_payment_method_ID
8971: AND popf.PAYMENT_TYPE_ID = ppt.PAYMENT_TYPE_ID
8972: AND ppt.PAYMENT_TYPE_NAME = 'BACS Tape'

Line 8989: pay_payroll_actions ppa

8985: select (sum(ppp.value) * 100) amount
8986: from pay_pre_payments ppp,
8987: pay_org_payment_methods_f popmf,
8988: pay_assignment_actions paa,
8989: pay_payroll_actions ppa
8990: where ppp.ASSIGNMENT_ACTION_ID = c_prepay_asg_action_id
8991: and popmf.ORG_PAYMENT_METHOD_ID = ppp.ORG_PAYMENT_METHOD_ID
8992: and popmf.defined_balance_id is not null
8993: and ppa.payroll_action_id = paa.payroll_action_id

Line 9012: pay_payroll_actions pact,

9008: || paa.assignment_action_id),16)) max_asg_act_id,
9009: MAX(pact.effective_date) effective_date
9010: FROM pay_assignment_actions paa,
9011: per_all_assignments_f paaf,
9012: pay_payroll_actions pact,
9013: per_time_periods ptp,
9014: pay_assignment_actions paa1, --Prepayments
9015: pay_payroll_actions ppa1, --Prepayments
9016: pay_action_interlocks pai --Prepayments

Line 9015: pay_payroll_actions ppa1, --Prepayments

9011: per_all_assignments_f paaf,
9012: pay_payroll_actions pact,
9013: per_time_periods ptp,
9014: pay_assignment_actions paa1, --Prepayments
9015: pay_payroll_actions ppa1, --Prepayments
9016: pay_action_interlocks pai --Prepayments
9017: WHERE paa.assignment_id = paaf.assignment_id
9018: AND paaf.person_id = p_person_id
9019: AND paa.payroll_action_id = pact.payroll_action_id

Line 9053: ,pay_payroll_actions pact

9049: || paa.assignment_action_id),16)) max_asg_act_id
9050: ,max (pact.effective_date) effective_date
9051: FROM pay_assignment_actions paa
9052: ,per_all_assignments_f paaf
9053: ,pay_payroll_actions pact
9054: ,per_time_periods ptp
9055: WHERE paa.assignment_id = paaf.assignment_id
9056: AND paaf.person_id = p_person_id
9057: AND paa.payroll_action_id = pact.payroll_action_id

Line 9102: ,pay_payroll_actions pact

9098: (select null
9099: */
9100: SELECT min (act.assignment_action_id)
9101: FROM pay_action_classifications class
9102: ,pay_payroll_actions pact
9103: ,pay_assignment_actions act
9104: ,per_all_assignments_f ass
9105: ,per_periods_of_service pos
9106: WHERE pos.person_id = p_person_id

Line 9121: pay_payroll_actions ppa

9117: IS
9118: SELECT 'Y' this_prepayment
9119: FROM pay_action_interlocks pai,
9120: pay_assignment_actions paa,
9121: pay_payroll_actions ppa
9122: WHERE paa.payroll_action_id = ppa.payroll_action_id
9123: AND paa.assignment_action_id = pai.locking_action_id
9124: AND ppa.action_type in ('P','U')
9125: AND ppa.payroll_action_id = g_pre_pact_id

Line 9213: pay_payroll_actions ppa

9209: cursor csr_asg_act_oth_asgs(c_asg_id number) is
9210: select max(paa.assignment_action_id) asg_act_id from per_all_assignments_f paaf,
9211: per_all_assignments_f paaf1,
9212: pay_assignment_actions paa,
9213: pay_payroll_actions ppa
9214: where paaf.assignment_id = c_asg_id
9215: and paaf1.person_id = paaf.person_id
9216: and paaf1.assignment_id <> c_asg_id
9217: and paaf1.assignment_id = paa.assignment_id

Line 9244: FROM pay_payroll_actions pact

9240: -- To fetch First FPS parameter
9241: /*CURSOR csr_parameter_info IS
9242: SELECT substr (pay_gb_eoy_archive.get_parameter (legislative_parameters, 'FIRST_FPS'), 1,1) first_fps,
9243: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref
9244: FROM pay_payroll_actions pact
9245: , pay_assignment_actions paa
9246: WHERE paa.assignment_action_id = p_assactid
9247: AND pact.payroll_action_id = paa.payroll_action_id;
9248: */

Line 9274: , pay_payroll_actions pact

9270: , '0')
9271: || paa.assignment_action_id), 16))
9272: , max (pact.effective_date) effective_date
9273: FROM pay_assignment_actions paa
9274: , pay_payroll_actions pact
9275: , per_time_periods ptp
9276: WHERE paa.assignment_id = p_asgid
9277: AND paa.payroll_action_id = pact.payroll_action_id
9278: AND pact.payroll_id = l_payroll

Line 9297: , pay_payroll_actions pact

9293: , '0')
9294: || paa.assignment_action_id), 16))
9295: , max (pact.effective_date) effective_date
9296: FROM pay_assignment_actions paa
9297: , pay_payroll_actions pact
9298: , per_time_periods ptp
9299: WHERE paa.assignment_id = p_asgid
9300: AND paa.payroll_action_id = pact.payroll_action_id
9301: AND pact.time_period_id = ptp.time_period_id

Line 9336: pay_payroll_actions ppa1, --Prepayments

9332:
9333: cursor csr_chk_prepayment_run(c_assignment_action_id number) is
9334: select count(*) from pay_assignment_actions paa, --run
9335: pay_assignment_actions paa1, --Prepayments
9336: pay_payroll_actions ppa1, --Prepayments
9337: pay_action_interlocks pai --Prepayments
9338: where paa.assignment_action_id = c_assignment_action_id --9917796
9339: AND paa.assignment_action_id = pai.locked_action_id
9340: AND paa1.assignment_action_id = pai.locking_action_id

Line 9351: FROM pay_payroll_actions ppa, --Current pactid

9347: IS
9348:
9349: SELECT count(distinct act.assignment_action_id),
9350: min(act.assignment_action_id) assignment_action_id
9351: FROM pay_payroll_actions ppa, --Current pactid
9352: pay_payroll_actions appa, --Payroll Run
9353: pay_payroll_actions appa2, --Prepayments
9354: pay_assignment_actions act, --Payroll Run
9355: pay_assignment_actions act1, --Prepayments

Line 9352: pay_payroll_actions appa, --Payroll Run

9348:
9349: SELECT count(distinct act.assignment_action_id),
9350: min(act.assignment_action_id) assignment_action_id
9351: FROM pay_payroll_actions ppa, --Current pactid
9352: pay_payroll_actions appa, --Payroll Run
9353: pay_payroll_actions appa2, --Prepayments
9354: pay_assignment_actions act, --Payroll Run
9355: pay_assignment_actions act1, --Prepayments
9356: pay_action_interlocks pai, --Prepayments

Line 9353: pay_payroll_actions appa2, --Prepayments

9349: SELECT count(distinct act.assignment_action_id),
9350: min(act.assignment_action_id) assignment_action_id
9351: FROM pay_payroll_actions ppa, --Current pactid
9352: pay_payroll_actions appa, --Payroll Run
9353: pay_payroll_actions appa2, --Prepayments
9354: pay_assignment_actions act, --Payroll Run
9355: pay_assignment_actions act1, --Prepayments
9356: pay_action_interlocks pai, --Prepayments
9357: per_all_assignments_f as1

Line 9378: FROM pay_payroll_actions ppa, --Current pactid

9374: p_pre_pact_id NUMBER)
9375: IS
9376:
9377: SELECT max(act.assignment_action_id) assignment_action_id
9378: FROM pay_payroll_actions ppa, --Current pactid
9379: pay_payroll_actions appa, --Payroll Run
9380: pay_payroll_actions appa2, --Prepayments
9381: pay_assignment_actions act, --Payroll Run
9382: pay_assignment_actions act1, --Prepayments

Line 9379: pay_payroll_actions appa, --Payroll Run

9375: IS
9376:
9377: SELECT max(act.assignment_action_id) assignment_action_id
9378: FROM pay_payroll_actions ppa, --Current pactid
9379: pay_payroll_actions appa, --Payroll Run
9380: pay_payroll_actions appa2, --Prepayments
9381: pay_assignment_actions act, --Payroll Run
9382: pay_assignment_actions act1, --Prepayments
9383: pay_action_interlocks pai, --Prepayments

Line 9380: pay_payroll_actions appa2, --Prepayments

9376:
9377: SELECT max(act.assignment_action_id) assignment_action_id
9378: FROM pay_payroll_actions ppa, --Current pactid
9379: pay_payroll_actions appa, --Payroll Run
9380: pay_payroll_actions appa2, --Prepayments
9381: pay_assignment_actions act, --Payroll Run
9382: pay_assignment_actions act1, --Prepayments
9383: pay_action_interlocks pai, --Prepayments
9384: per_all_assignments_f as1

Line 9404: pay_payroll_actions ppa, --Current pactid

9400: IS
9401: SELECT act.assignment_id assignment_id,
9402: max(act.assignment_action_id) asg_act_id
9403: FROM
9404: pay_payroll_actions ppa, --Current pactid
9405: pay_payroll_actions appa, --Payroll Run
9406: pay_payroll_actions appa2, --Prepayments
9407: pay_assignment_actions act, --Payroll Run
9408: pay_assignment_actions act1, --Prepayments

Line 9405: pay_payroll_actions appa, --Payroll Run

9401: SELECT act.assignment_id assignment_id,
9402: max(act.assignment_action_id) asg_act_id
9403: FROM
9404: pay_payroll_actions ppa, --Current pactid
9405: pay_payroll_actions appa, --Payroll Run
9406: pay_payroll_actions appa2, --Prepayments
9407: pay_assignment_actions act, --Payroll Run
9408: pay_assignment_actions act1, --Prepayments
9409: pay_action_interlocks pai, --Prepayments

Line 9406: pay_payroll_actions appa2, --Prepayments

9402: max(act.assignment_action_id) asg_act_id
9403: FROM
9404: pay_payroll_actions ppa, --Current pactid
9405: pay_payroll_actions appa, --Payroll Run
9406: pay_payroll_actions appa2, --Prepayments
9407: pay_assignment_actions act, --Payroll Run
9408: pay_assignment_actions act1, --Prepayments
9409: pay_action_interlocks pai, --Prepayments
9410: per_all_assignments_f as1

Line 9443: FROM pay_payroll_actions ppa, --Current pactid

9439: IS
9440:
9441: SELECT count(distinct act.assignment_action_id),
9442: max(act.assignment_action_id) assignment_action_id
9443: FROM pay_payroll_actions ppa, --Current pactid
9444: pay_payroll_actions appa, --Payroll Run
9445: pay_payroll_actions appa2, --Prepayments
9446: pay_assignment_actions act, --Payroll Run
9447: pay_assignment_actions act1, --Prepayments

Line 9444: pay_payroll_actions appa, --Payroll Run

9440:
9441: SELECT count(distinct act.assignment_action_id),
9442: max(act.assignment_action_id) assignment_action_id
9443: FROM pay_payroll_actions ppa, --Current pactid
9444: pay_payroll_actions appa, --Payroll Run
9445: pay_payroll_actions appa2, --Prepayments
9446: pay_assignment_actions act, --Payroll Run
9447: pay_assignment_actions act1, --Prepayments
9448: pay_action_interlocks pai, --Prepayments

Line 9445: pay_payroll_actions appa2, --Prepayments

9441: SELECT count(distinct act.assignment_action_id),
9442: max(act.assignment_action_id) assignment_action_id
9443: FROM pay_payroll_actions ppa, --Current pactid
9444: pay_payroll_actions appa, --Payroll Run
9445: pay_payroll_actions appa2, --Prepayments
9446: pay_assignment_actions act, --Payroll Run
9447: pay_assignment_actions act1, --Prepayments
9448: pay_action_interlocks pai, --Prepayments
9449: per_all_assignments_f as1

Line 9618: pay_payroll_actions ppa,

9614: cursor chk_processed_in_prepay(c_cur_asg_action_id number) is
9615: select pai.locking_action_id
9616: from
9617: pay_action_interlocks pai,
9618: pay_payroll_actions ppa,
9619: pay_assignment_actions paa
9620: where pai.locked_action_id = c_cur_asg_action_id
9621: and ppa.action_type in ('P','U')
9622: and paa.payroll_action_id = ppa.payroll_action_id

Line 9628: pay_payroll_actions ppa,

9624:
9625: /* cursor csr_is_retry_request is
9626: select 'Y' from fnd_concurrent_programs fcp,
9627: fnd_concurrent_requests fcr,
9628: pay_payroll_actions ppa,
9629: pay_assignment_actions paa
9630: where paa.assignment_action_id = p_assactid
9631: and ppa.payroll_action_id = paa.payroll_action_id
9632: and ppa.request_id = fcr.request_id

Line 9655: pay_payroll_actions ppa

9651:
9652: -- to check whether the given assignment is processed in given prepay payroll_action id
9653: cursor csr_rti_rpt_proc_prepay(c_ni_rpt_asg_id number,c_pre_pay_action_id number) is
9654: select 'Y' from pay_assignment_actions paa,
9655: pay_payroll_actions ppa
9656: where
9657: ppa.payroll_action_id = c_pre_pay_action_id
9658: and ppa.payroll_action_id = paa.payroll_action_id
9659: and paa.assignment_id = c_ni_rpt_asg_id

Line 9672: ,pay_payroll_actions pact

9668: || paa.assignment_action_id),16)) max_asg_act_id
9669: , max(pact.effective_date) effective_date
9670:
9671: FROM pay_assignment_actions paa
9672: ,pay_payroll_actions pact
9673: ,per_time_periods ptp
9674: WHERE paa.assignment_id = c_asg_id
9675: AND paa.payroll_action_id = pact.payroll_action_id
9676: AND pact.time_period_id = ptp.time_period_id

Line 9695: pay_payroll_actions pact,

9691: IS
9692: SELECT count(distinct paa1.assignment_id)
9693: FROM pay_assignment_actions paa,
9694: per_all_assignments_f paaf,
9695: pay_payroll_actions pact,
9696: per_time_periods ptp,
9697: pay_assignment_actions paa1, --Prepayments
9698: pay_payroll_actions ppa1, --Prepayments
9699: pay_action_interlocks pai --Prepayments

Line 9698: pay_payroll_actions ppa1, --Prepayments

9694: per_all_assignments_f paaf,
9695: pay_payroll_actions pact,
9696: per_time_periods ptp,
9697: pay_assignment_actions paa1, --Prepayments
9698: pay_payroll_actions ppa1, --Prepayments
9699: pay_action_interlocks pai --Prepayments
9700: WHERE paa.assignment_id = paaf.assignment_id
9701: AND paaf.person_id = p_person_id
9702: AND paa.payroll_action_id = pact.payroll_action_id

Line 9717: FROM pay_payroll_actions pact,

9713: -- To fetch First FPS parameter
9714: CURSOR csr_parameter_info IS
9715: SELECT fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date,
9716: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id
9717: FROM pay_payroll_actions pact,
9718: pay_assignment_actions paa
9719: WHERE paa.assignment_action_id = p_assactid
9720: AND pact.payroll_action_id = paa.payroll_action_id;
9721:

Line 9732: , pay_payroll_actions pact

9728: , max (pact.effective_date) effective_date
9729:
9730: FROM per_all_assignments_f paaf,
9731: pay_assignment_actions paa
9732: , pay_payroll_actions pact
9733: , per_time_periods ptp
9734: WHERE paa.assignment_id = paaf.assignment_id
9735: and paaf.person_id = person_id
9736: AND paa.payroll_action_id = pact.payroll_action_id

Line 9776: pay_payroll_actions ppa

9772:
9773: cursor csr_fps_check(p_asg_id number) is
9774: select count(*)
9775: from pay_assignment_actions paa,
9776: pay_payroll_actions ppa
9777: where paa.assignment_id = p_asg_id
9778: and paa.action_status ='C'
9779: and paa.assignment_action_id <> p_assactid
9780: and ppa.payroll_action_id = paa.payroll_action_id

Line 10991: pay_payroll_actions ppa,

10987: l_payroll_asg_acts(l_tab_counter) := l_cur_asg_action_id;
10988: begin
10989: select ppa.payroll_action_id into l_oth_min_pre_pay_id from
10990: pay_action_interlocks pai,
10991: pay_payroll_actions ppa,
10992: pay_assignment_actions paa
10993: where
10994: pai.locked_action_id = l_cur_asg_action_id
10995: and pai.locking_action_id = paa.assignment_action_id

Line 12967: select * from pay_payroll_actions ppa,

12963: end if;
12964: hr_utility.set_location('record_count: ' || record_count ,1000);
12965: /* else -- else for l_archive_tab_ni_rpt.count > 0
12966: -- get the latest prepayment and the payroll details.
12967: select * from pay_payroll_actions ppa,
12968: get_ni_only_asg_details(l_ni_rpt_asg_id,l_archive_tab_ni_rpt,
12969: end if; -- end if for l_archive_tab_ni_rpt.count > 0
12970: */
12971:

Line 13092: FROM pay_payroll_actions pact

13088: date_scheme date;
13089: CURSOR csr_is_etext_report
13090: IS
13091: SELECT report_type
13092: FROM pay_payroll_actions pact
13093: WHERE pact.payroll_action_id = pactid;
13094: l_is_etext_report VARCHAR2(50);
13095: l_request_id fnd_concurrent_requests.request_id%TYPE;
13096: xml_layout BOOLEAN;

Line 13119: FROM pay_payroll_actions pact,

13115: hoi.org_information7 econ_number,
13116: pact.business_group_id bus_grp_id,
13117: pact.action_parameter_group_id act_param_grp_id,
13118: org_information19 service_company
13119: FROM pay_payroll_actions pact,
13120: hr_organization_information hoi
13121: WHERE pact.payroll_action_id =pactid
13122: AND pact.business_group_id = hoi.organization_id
13123: AND hoi.org_information_context = 'Tax Details References'

Line 13156: FROM pay_payroll_actions

13152: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'HMRC_ADVAN'),1,20) hmrc_advance_received,
13153: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'CIS_DEDUCT'),1,20) cis_deductions,
13154: substr(legislative_parameters,instr(legislative_parameters,'VERSION=')+8) version,
13155: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'DATE_SCHEME'),1,10)) date_scheme
13156: FROM pay_payroll_actions
13157: WHERE payroll_action_id = pactid;
13158:
13159: l_payroll_rec csr_payroll_details%rowtype;
13160: l_tax_details csr_payroll_details_2%rowtype;

Line 13195: FROM pay_payroll_actions pact

13191: SELECT legislative_parameters para,
13192: fnd_number.number_to_canonical(request_id) control_id,
13193: report_type,
13194: business_group_id
13195: FROM pay_payroll_actions pact
13196: WHERE payroll_action_id = pactid;
13197:
13198: CURSOR csr_header_det(p_bus_id NUMBER, p_tax_ref VARCHAR2)
13199: IS

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

13209:
13210: CURSOR csr_payroll_details
13211: IS
13212: SELECT ppf.PAYROLL_NAME , ppapre.EFFECTIVE_DATE
13213: from pay_payrolls_f ppf,pay_payroll_actions ppapre,pay_payroll_actions ppa
13214: WHERE ppa.payroll_action_id = pactid
13215: and ppf.payroll_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PAYROLL_ID'),1,20)
13216: and ppapre.payroll_action_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PRE_PAY_ID'),1,20);
13217:

Line 13223: FROM pay_payroll_actions ppa,

13219: CURSOR get_asg_action_id_error
13220: IS
13221: SELECT DISTINCT paa.assignment_action_id asg_action_id,
13222: assignment_id
13223: FROM pay_payroll_actions ppa,
13224: pay_assignment_actions paa
13225: WHERE ppa.payroll_action_id = pactid -- pact_id
13226: AND paa.payroll_action_id = ppa.payroll_action_id
13227: AND paa.action_status = 'E';

Line 13391: FROM pay_payroll_actions ppa,

13387: CURSOR get_asg_action_id
13388: IS
13389: SELECT DISTINCT paa.assignment_action_id asg_action_id,
13390: assignment_id
13391: FROM pay_payroll_actions ppa,
13392: pay_assignment_actions paa
13393: WHERE ppa.payroll_action_id = pactid -- pact_id
13394: AND paa.payroll_action_id = ppa.payroll_action_id
13395: AND paa.action_status = 'C';

Line 13402: FROM pay_payroll_actions ppa,

13398: CURSOR get_asg_action_id_error
13399: IS
13400: SELECT DISTINCT paa.assignment_action_id asg_action_id,
13401: assignment_id
13402: FROM pay_payroll_actions ppa,
13403: pay_assignment_actions paa
13404: WHERE ppa.payroll_action_id = pactid -- pact_id
13405: AND paa.payroll_action_id = ppa.payroll_action_id
13406: AND paa.action_status = 'E';

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

13460: AND message_level = 'W'
13461: AND payroll_id = 100;
13462:
13463: cursor csr_get_prepayment_date(p_pre_pact_id number) is
13464: select EFFECTIVE_DATE from pay_payroll_actions where payroll_action_id = p_pre_pact_id;
13465:
13466: err_msg varchar2(255);--csr_err_msg%rowtype;
13467: et_asg_rec get_person_details%rowtype;
13468: asg_rec get_person_details%rowtype;

Line 13597: FROM pay_payroll_actions ppa,

13593:
13594: CURSOR get_person_count
13595: IS
13596: SELECT COUNT(DISTINCT(paaf.person_id))
13597: FROM pay_payroll_actions ppa,
13598: pay_assignment_actions paa,
13599: per_all_assignments_f paaf
13600: WHERE ppa.payroll_action_id = pactid -- pact_id
13601: AND paa.payroll_action_id = ppa.payroll_action_id