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

Line 1433: FROM pay_payroll_actions ppa,

1429: IS
1430: SELECT ptp.regular_payment_date,
1431: ptp.period_num,
1432: ptp.period_type
1433: FROM pay_payroll_actions ppa,
1434: pay_assignment_actions paa,
1435: per_time_periods ptp
1436: WHERE assignment_action_id = p_last_asg_action_id
1437: AND ppa.time_period_id = ptp.time_period_id

Line 1533: pay_payroll_actions pact,

1529: /*+ USE_NL(paa, pact, ptp) */
1530: MIN(ptp.start_date) payroll_period_start_date,
1531: MAX(ptp.end_date) payroll_period_end_date
1532: FROM pay_assignment_actions paa,
1533: pay_payroll_actions pact,
1534: per_time_periods ptp,
1535: pay_assignment_actions paa1, --Prepayments
1536: pay_payroll_actions ppa1, --Prepayments
1537: pay_action_interlocks pai --Prepayments

Line 1536: pay_payroll_actions ppa1, --Prepayments

1532: FROM pay_assignment_actions paa,
1533: pay_payroll_actions pact,
1534: per_time_periods ptp,
1535: pay_assignment_actions paa1, --Prepayments
1536: pay_payroll_actions ppa1, --Prepayments
1537: pay_action_interlocks pai --Prepayments
1538: WHERE paa.assignment_id = p_asgid
1539: AND paa.payroll_action_id = pact.payroll_action_id
1540: AND pact.time_period_id = ptp.time_period_id

Line 1581: from pay_payroll_actions ppa_prev,

1577: --Below cursor fetches the Last Pre-Payment id
1578: CURSOR csr_last_pre_pay_id (c_asg_id NUMBER)
1579: IS
1580: select ppa_prev.payroll_action_id
1581: from pay_payroll_actions ppa_prev,
1582: pay_payroll_actions ppa_current
1583: where ppa_prev.action_type IN ('P','U')
1584: and ppa_prev.payroll_id = ppa_current.payroll_id
1585: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id

Line 1582: pay_payroll_actions ppa_current

1578: CURSOR csr_last_pre_pay_id (c_asg_id NUMBER)
1579: IS
1580: select ppa_prev.payroll_action_id
1581: from pay_payroll_actions ppa_prev,
1582: pay_payroll_actions ppa_current
1583: where ppa_prev.action_type IN ('P','U')
1584: and ppa_prev.payroll_id = ppa_current.payroll_id
1585: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id
1586: and ppa_current.payroll_action_id = g_pre_pact_id

Line 1589: from pay_payroll_actions ppa_max,

1585: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id
1586: and ppa_current.payroll_action_id = g_pre_pact_id
1587: and ppa_prev.payroll_action_id =
1588: (select max(ppa_max.payroll_action_id)
1589: from pay_payroll_actions ppa_max,
1590: pay_assignment_actions paa_max
1591: where ppa_max.payroll_id = ppa_current.payroll_id
1592: and ppa_max.payroll_action_id < ppa_current.payroll_action_id
1593: and ppa_max.action_type IN ('P','U')

Line 1602: pay_payroll_actions ppa_prepay,

1598: CURSOR csr_last_fps_asg_act_id (c_last_pre_pay_id NUMBER, c_asg_id NUMBER)
1599: IS
1600: select paa_fps.assignment_action_id
1601: from pay_assignment_actions paa_prepay,
1602: pay_payroll_actions ppa_prepay,
1603: pay_assignment_actions paa_fps,
1604: pay_payroll_actions ppa_fps,
1605: pay_action_interlocks pai
1606: where ppa_prepay.payroll_action_id = c_last_pre_pay_id

Line 1604: pay_payroll_actions ppa_fps,

1600: select paa_fps.assignment_action_id
1601: from pay_assignment_actions paa_prepay,
1602: pay_payroll_actions ppa_prepay,
1603: pay_assignment_actions paa_fps,
1604: pay_payroll_actions ppa_fps,
1605: pay_action_interlocks pai
1606: where ppa_prepay.payroll_action_id = c_last_pre_pay_id
1607: and ppa_prepay.payroll_action_id = paa_prepay.payroll_action_id
1608: and paa_prepay.assignment_action_id = pai.locked_action_id

Line 2251: FROM pay_payroll_actions ppa,

2247: IS
2248: SELECT ptp.regular_payment_date,
2249: ptp.period_num,
2250: ptp.period_type
2251: FROM pay_payroll_actions ppa,
2252: pay_assignment_actions paa,
2253: per_time_periods ptp
2254: WHERE assignment_action_id = l_last_asg_action_id
2255: AND ppa.time_period_id = ptp.time_period_id

Line 2341: pay_payroll_actions pact,

2337: /*+ USE_NL(paa, pact, ptp) */
2338: MIN(ptp.start_date) payroll_period_start_date,
2339: MAX(ptp.end_date) payroll_period_end_date
2340: FROM pay_assignment_actions paa,
2341: pay_payroll_actions pact,
2342: per_time_periods ptp,
2343: pay_assignment_actions paa1, --Prepayments
2344: pay_payroll_actions ppa1, --Prepayments
2345: pay_action_interlocks pai --Prepayments

Line 2344: pay_payroll_actions ppa1, --Prepayments

2340: FROM pay_assignment_actions paa,
2341: pay_payroll_actions pact,
2342: per_time_periods ptp,
2343: pay_assignment_actions paa1, --Prepayments
2344: pay_payroll_actions ppa1, --Prepayments
2345: pay_action_interlocks pai --Prepayments
2346: WHERE paa.assignment_id = p_asgid
2347: AND paa.payroll_action_id = pact.payroll_action_id
2348: AND pact.time_period_id = ptp.time_period_id

Line 2389: from pay_payroll_actions ppa_prev,

2385: --Below cursor fetches the Last Pre-Payment id
2386: CURSOR csr_last_pre_pay_id (c_asg_id NUMBER)
2387: IS
2388: select ppa_prev.payroll_action_id
2389: from pay_payroll_actions ppa_prev,
2390: pay_payroll_actions ppa_current
2391: where ppa_prev.action_type IN ('P','U')
2392: and ppa_prev.payroll_id = ppa_current.payroll_id
2393: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id

Line 2390: pay_payroll_actions ppa_current

2386: CURSOR csr_last_pre_pay_id (c_asg_id NUMBER)
2387: IS
2388: select ppa_prev.payroll_action_id
2389: from pay_payroll_actions ppa_prev,
2390: pay_payroll_actions ppa_current
2391: where ppa_prev.action_type IN ('P','U')
2392: and ppa_prev.payroll_id = ppa_current.payroll_id
2393: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id
2394: and ppa_current.payroll_action_id = g_pre_pact_id

Line 2397: from pay_payroll_actions ppa_max,

2393: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id
2394: and ppa_current.payroll_action_id = g_pre_pact_id
2395: and ppa_prev.payroll_action_id =
2396: (select max(ppa_max.payroll_action_id)
2397: from pay_payroll_actions ppa_max,
2398: pay_assignment_actions paa_max
2399: where ppa_max.payroll_id = ppa_current.payroll_id
2400: and ppa_max.payroll_action_id < ppa_current.payroll_action_id
2401: and ppa_max.action_type IN ('P','U')

Line 2410: pay_payroll_actions ppa_prepay,

2406: CURSOR csr_last_fps_asg_act_id (c_last_pre_pay_id NUMBER, c_asg_id NUMBER)
2407: IS
2408: select paa_fps.assignment_action_id
2409: from pay_assignment_actions paa_prepay,
2410: pay_payroll_actions ppa_prepay,
2411: pay_assignment_actions paa_fps,
2412: pay_payroll_actions ppa_fps,
2413: pay_action_interlocks pai
2414: where ppa_prepay.payroll_action_id = c_last_pre_pay_id

Line 2412: pay_payroll_actions ppa_fps,

2408: select paa_fps.assignment_action_id
2409: from pay_assignment_actions paa_prepay,
2410: pay_payroll_actions ppa_prepay,
2411: pay_assignment_actions paa_fps,
2412: pay_payroll_actions ppa_fps,
2413: pay_action_interlocks pai
2414: where ppa_prepay.payroll_action_id = c_last_pre_pay_id
2415: and ppa_prepay.payroll_action_id = paa_prepay.payroll_action_id
2416: and paa_prepay.assignment_action_id = pai.locked_action_id

Line 2457: pay_payroll_actions pact,

2453: || paa.assignment_action_id),16)) max_asg_act_id,
2454: MAX(pact.effective_date) effective_date
2455: FROM per_all_assignments_f paaf,
2456: pay_assignment_actions paa,
2457: pay_payroll_actions pact,
2458: per_time_periods ptp,
2459: pay_assignment_actions paa1, --Prepayments
2460: pay_payroll_actions ppa1, --Prepayments
2461: pay_action_interlocks pai --Prepayments

Line 2460: pay_payroll_actions ppa1, --Prepayments

2456: pay_assignment_actions paa,
2457: pay_payroll_actions pact,
2458: per_time_periods ptp,
2459: pay_assignment_actions paa1, --Prepayments
2460: pay_payroll_actions ppa1, --Prepayments
2461: pay_action_interlocks pai --Prepayments
2462: WHERE paaf.person_id = p_person_rec.person_id--59437
2463: AND sysdate between paaf.effective_start_date and paaf.effective_end_date
2464: AND paa.assignment_id = paaf.assignment_id

Line 3064: FROM pay_payroll_actions ppa,

3060: IS
3061: SELECT ptp.regular_payment_date,
3062: ptp.period_num,
3063: ptp.period_type
3064: FROM pay_payroll_actions ppa,
3065: pay_assignment_actions paa,
3066: per_time_periods ptp
3067: WHERE assignment_action_id = p_last_asg_action_id
3068: AND ppa.time_period_id = ptp.time_period_id

Line 3155: pay_payroll_actions pact,

3151: /*+ USE_NL(paa, pact, ptp) */
3152: MIN(ptp.start_date) payroll_period_start_date,
3153: MAX(ptp.end_date) payroll_period_end_date
3154: FROM pay_assignment_actions paa,
3155: pay_payroll_actions pact,
3156: per_time_periods ptp,
3157: pay_assignment_actions paa1, --Prepayments
3158: pay_payroll_actions ppa1, --Prepayments
3159: pay_action_interlocks pai --Prepayments

Line 3158: pay_payroll_actions ppa1, --Prepayments

3154: FROM pay_assignment_actions paa,
3155: pay_payroll_actions pact,
3156: per_time_periods ptp,
3157: pay_assignment_actions paa1, --Prepayments
3158: pay_payroll_actions ppa1, --Prepayments
3159: pay_action_interlocks pai --Prepayments
3160: WHERE paa.assignment_id = p_asgid
3161: AND paa.payroll_action_id = pact.payroll_action_id
3162: AND pact.time_period_id = ptp.time_period_id

Line 3203: from pay_payroll_actions ppa_prev,

3199: --Below cursor fetches the Last Pre-Payment id
3200: CURSOR csr_last_pre_pay_id (c_asg_id NUMBER)
3201: IS
3202: select ppa_prev.payroll_action_id
3203: from pay_payroll_actions ppa_prev,
3204: pay_payroll_actions ppa_current
3205: where ppa_prev.action_type IN ('P','U')
3206: and ppa_prev.payroll_id = ppa_current.payroll_id
3207: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id

Line 3204: pay_payroll_actions ppa_current

3200: CURSOR csr_last_pre_pay_id (c_asg_id NUMBER)
3201: IS
3202: select ppa_prev.payroll_action_id
3203: from pay_payroll_actions ppa_prev,
3204: pay_payroll_actions ppa_current
3205: where ppa_prev.action_type IN ('P','U')
3206: and ppa_prev.payroll_id = ppa_current.payroll_id
3207: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id
3208: and ppa_current.payroll_action_id = g_pre_pact_id

Line 3211: from pay_payroll_actions ppa_max,

3207: and ppa_prev.payroll_action_id < ppa_current.payroll_action_id
3208: and ppa_current.payroll_action_id = g_pre_pact_id
3209: and ppa_prev.payroll_action_id =
3210: (select max(ppa_max.payroll_action_id)
3211: from pay_payroll_actions ppa_max,
3212: pay_assignment_actions paa_max
3213: where ppa_max.payroll_id = ppa_current.payroll_id
3214: and ppa_max.payroll_action_id < ppa_current.payroll_action_id
3215: and ppa_max.action_type IN ('P','U')

Line 3224: pay_payroll_actions ppa_prepay,

3220: CURSOR csr_last_fps_asg_act_id (c_last_pre_pay_id NUMBER, c_asg_id NUMBER)
3221: IS
3222: select paa_fps.assignment_action_id
3223: from pay_assignment_actions paa_prepay,
3224: pay_payroll_actions ppa_prepay,
3225: pay_assignment_actions paa_fps,
3226: pay_payroll_actions ppa_fps,
3227: pay_action_interlocks pai
3228: where ppa_prepay.payroll_action_id = c_last_pre_pay_id

Line 3226: pay_payroll_actions ppa_fps,

3222: select paa_fps.assignment_action_id
3223: from pay_assignment_actions paa_prepay,
3224: pay_payroll_actions ppa_prepay,
3225: pay_assignment_actions paa_fps,
3226: pay_payroll_actions ppa_fps,
3227: pay_action_interlocks pai
3228: where ppa_prepay.payroll_action_id = c_last_pre_pay_id
3229: and ppa_prepay.payroll_action_id = paa_prepay.payroll_action_id
3230: and paa_prepay.assignment_action_id = pai.locked_action_id

Line 6019: FROM pay_payroll_actions

6015: SELECT SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PRE_PAY_ID'),1,20) pre_pay_id,
6016: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS'),1,20) first_fps,
6017: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
6018: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date
6019: FROM pay_payroll_actions
6020: WHERE payroll_action_id = pactid;
6021:
6022: CURSOR csr_get_payroll_id(c_pre_pact_id NUMBER)
6023: IS

Line 6025: FROM pay_payroll_actions

6021:
6022: CURSOR csr_get_payroll_id(c_pre_pact_id NUMBER)
6023: IS
6024: SELECT payroll_id
6025: FROM pay_payroll_actions
6026: WHERE payroll_action_id = c_pre_pact_id;
6027:
6028: -- cursor to check whether first fps is run for this payroll or not
6029: cursor c_first_fps_ran(c_payroll_id number) is

Line 6030: select 'Y' from pay_payroll_actions ppa

6026: WHERE payroll_action_id = c_pre_pact_id;
6027:
6028: -- cursor to check whether first fps is run for this payroll or not
6029: cursor c_first_fps_ran(c_payroll_id number) is
6030: select 'Y' from pay_payroll_actions ppa
6031: where c_payroll_id = pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYROLL_ID')
6032: and pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS') = 'Y'
6033: and ACTION_STATUS = 'C'
6034: and exists (select 1 from pay_gb_fps_details where PAYROLL_ACTION_ID = ppa.payroll_action_id);

Line 6038: from pay_payroll_actions ppa

6034: and exists (select 1 from pay_gb_fps_details where PAYROLL_ACTION_ID = ppa.payroll_action_id);
6035:
6036: cursor csr_other_prepay_pactid(c_tax_ref varchar2) is
6037: select distinct ppa.payroll_action_id
6038: from pay_payroll_actions ppa
6039: where ppa.effective_date >= sysdate - 30
6040: and ppa.action_type in ('P','U')
6041: and ppa.action_status ='C'
6042: and ppa.payroll_id in (select distinct payroll_id

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

6112: RAISE first_fps_indicator_error;
6113: end if;
6114:
6115: sqlstr := 'select distinct PERSON_ID '|| 'from per_all_assignments_f paaf, '
6116: || 'pay_payroll_actions ppa '|| 'where ppa.payroll_action_id = :payroll_action_id '
6117: || 'and ppa.business_group_id = paaf.business_group_id '|| ' and paaf.payroll_id = '
6118: ||''''||l_payroll_id||''''|| ' order by person_id';
6119:
6120: hr_utility.trace(' Range Cursor Statement : '||sqlstr);

Line 6170: FROM pay_payroll_actions pact

6166: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS'),1,1) first_fps,
6167: effective_date,
6168: business_group_id,
6169: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date
6170: FROM pay_payroll_actions pact
6171: WHERE payroll_action_id = pactid;
6172:
6173: CURSOR csr_asg(c_asg_id NUMBER, c_effective_date DATE)
6174: IS

Line 6197: FROM --pay_payroll_actions ppa, --Current pactid

6193: c_effective_date DATE)
6194: IS
6195: SELECT DISTINCT act.assignment_id assignment_id,
6196: act.assignment_action_id asg_act_id
6197: FROM --pay_payroll_actions ppa, --Current pactid
6198: pay_payroll_actions appa, --Payroll Run
6199: pay_payroll_actions appa2, --Prepayments
6200: pay_assignment_actions act, --Payroll Run
6201: pay_assignment_actions act1, --Prepayments

Line 6198: pay_payroll_actions appa, --Payroll Run

6194: IS
6195: SELECT DISTINCT act.assignment_id assignment_id,
6196: act.assignment_action_id asg_act_id
6197: FROM --pay_payroll_actions ppa, --Current pactid
6198: pay_payroll_actions appa, --Payroll Run
6199: pay_payroll_actions appa2, --Prepayments
6200: pay_assignment_actions act, --Payroll Run
6201: pay_assignment_actions act1, --Prepayments
6202: pay_action_interlocks pai, --Prepayments

Line 6199: pay_payroll_actions appa2, --Prepayments

6195: SELECT DISTINCT act.assignment_id assignment_id,
6196: act.assignment_action_id asg_act_id
6197: FROM --pay_payroll_actions ppa, --Current pactid
6198: pay_payroll_actions appa, --Payroll Run
6199: pay_payroll_actions appa2, --Prepayments
6200: pay_assignment_actions act, --Payroll Run
6201: pay_assignment_actions act1, --Prepayments
6202: pay_action_interlocks pai, --Prepayments
6203: per_all_assignments_f as1

Line 6239: from pay_payroll_actions

6235:
6236: -- First FPS Cursors
6237: cursor csr_get_prepayment_date(p_pre_pact_id number) is
6238: select effective_date, payroll_id, business_group_id
6239: from pay_payroll_actions
6240: where payroll_action_id = p_pre_pact_id;
6241:
6242: cursor csr_asg_details(p_prepay_id number,p_prepayment_date date, l_prl_id number, l_bus_grp_id number) is
6243: select distinct paaf.assignment_id assignment_id,

Line 6250: --pay_payroll_actions paa

6246: pap.person_id
6247: from per_all_people_f pap,
6248: per_all_assignments_f paaf,
6249: per_assignment_status_types past --,
6250: --pay_payroll_actions paa
6251: where pap.person_id between stperson and endperson
6252: -- and paa.payroll_Action_id = p_prepay_id
6253: and pap.person_id = paaf.person_id
6254: and paaf.assignment_type = 'E'

Line 6305: , pay_payroll_actions pact

6301: , '0')
6302: || paa.assignment_action_id), 16))
6303: , max (pact.effective_date) effective_date
6304: FROM pay_assignment_actions paa
6305: , pay_payroll_actions pact
6306: , per_time_periods ptp
6307: WHERE paa.assignment_id = p_asgid
6308: AND paa.payroll_action_id = pact.payroll_action_id
6309: AND pact.payroll_id = l_payroll_id

Line 6327: FROM pay_payroll_actions ppa, --Current pactid

6323:
6324: SELECT max (act.assignment_action_id) assignment_id
6325: -- SELECT min (act.assignment_action_id) assignment_id
6326: -- SELECT max (act.assignment_id) assignment_id
6327: FROM pay_payroll_actions ppa, --Current pactid
6328: pay_payroll_actions appa, --Payroll Run
6329: pay_payroll_actions appa2, --Prepayments
6330: pay_assignment_actions act, --Payroll Run
6331: pay_assignment_actions act1, --Prepayments

Line 6328: pay_payroll_actions appa, --Payroll Run

6324: SELECT max (act.assignment_action_id) assignment_id
6325: -- SELECT min (act.assignment_action_id) assignment_id
6326: -- SELECT max (act.assignment_id) assignment_id
6327: FROM pay_payroll_actions ppa, --Current pactid
6328: pay_payroll_actions appa, --Payroll Run
6329: pay_payroll_actions appa2, --Prepayments
6330: pay_assignment_actions act, --Payroll Run
6331: pay_assignment_actions act1, --Prepayments
6332: pay_action_interlocks pai, --Prepayments

Line 6329: pay_payroll_actions appa2, --Prepayments

6325: -- SELECT min (act.assignment_action_id) assignment_id
6326: -- SELECT max (act.assignment_id) assignment_id
6327: FROM pay_payroll_actions ppa, --Current pactid
6328: pay_payroll_actions appa, --Payroll Run
6329: pay_payroll_actions appa2, --Prepayments
6330: pay_assignment_actions act, --Payroll Run
6331: pay_assignment_actions act1, --Prepayments
6332: pay_action_interlocks pai, --Prepayments
6333: per_all_assignments_f as1

Line 6363: FROM pay_payroll_actions ppa, --Current pactid

6359: IS
6360:
6361: SELECT max (act.assignment_action_id) assignment_id
6362: -- SELECT max (act.assignment_id) assignment_id
6363: FROM pay_payroll_actions ppa, --Current pactid
6364: pay_payroll_actions appa, --Payroll Run
6365: pay_payroll_actions appa2, --Prepayments
6366: pay_assignment_actions act, --Payroll Run
6367: pay_assignment_actions act1, --Prepayments

Line 6364: pay_payroll_actions appa, --Payroll Run

6360:
6361: SELECT max (act.assignment_action_id) assignment_id
6362: -- SELECT max (act.assignment_id) assignment_id
6363: FROM pay_payroll_actions ppa, --Current pactid
6364: pay_payroll_actions appa, --Payroll Run
6365: pay_payroll_actions appa2, --Prepayments
6366: pay_assignment_actions act, --Payroll Run
6367: pay_assignment_actions act1, --Prepayments
6368: pay_action_interlocks pai, --Prepayments

Line 6365: pay_payroll_actions appa2, --Prepayments

6361: SELECT max (act.assignment_action_id) assignment_id
6362: -- SELECT max (act.assignment_id) assignment_id
6363: FROM pay_payroll_actions ppa, --Current pactid
6364: pay_payroll_actions appa, --Payroll Run
6365: pay_payroll_actions appa2, --Prepayments
6366: pay_assignment_actions act, --Payroll Run
6367: pay_assignment_actions act1, --Prepayments
6368: pay_action_interlocks pai, --Prepayments
6369: per_all_assignments_f as1

Line 6409: ,pay_payroll_actions pact

6405: ,max(paa1.assignment_action_id)*/
6406: FROM pay_assignment_actions paa
6407: ,pay_assignment_actions paa1
6408: ,per_all_assignments_f paaf
6409: ,pay_payroll_actions pact
6410: ,pay_payroll_actions pact1
6411: ,per_time_periods ptp
6412: ,pay_action_interlocks pai
6413: WHERE paa.assignment_id = paaf.assignment_id

Line 6410: ,pay_payroll_actions pact1

6406: FROM pay_assignment_actions paa
6407: ,pay_assignment_actions paa1
6408: ,per_all_assignments_f paaf
6409: ,pay_payroll_actions pact
6410: ,pay_payroll_actions pact1
6411: ,per_time_periods ptp
6412: ,pay_action_interlocks pai
6413: WHERE paa.assignment_id = paaf.assignment_id
6414: AND paa.assignment_id <> p_asg_id

Line 6467: ,pay_payroll_actions pact

6463: distinct max(paa1.assignment_action_id) max_pre_act_id
6464: FROM pay_assignment_actions paa
6465: ,pay_assignment_actions paa1
6466: ,per_all_assignments_f paaf
6467: ,pay_payroll_actions pact
6468: ,pay_payroll_actions pact1
6469: ,per_time_periods ptp
6470: ,pay_action_interlocks pai
6471: WHERE paa.assignment_id = paaf.assignment_id

Line 6468: ,pay_payroll_actions pact1

6464: FROM pay_assignment_actions paa
6465: ,pay_assignment_actions paa1
6466: ,per_all_assignments_f paaf
6467: ,pay_payroll_actions pact
6468: ,pay_payroll_actions pact1
6469: ,per_time_periods ptp
6470: ,pay_action_interlocks pai
6471: WHERE paa.assignment_id = paaf.assignment_id
6472: AND paa.assignment_id = p_asg_id

Line 6513: pay_payroll_actions ppa,

6509: cursor chk_processed_in_prepay(c_cur_asg_action_id number) is
6510: select pai.locking_action_id
6511: from
6512: pay_action_interlocks pai,
6513: pay_payroll_actions ppa,
6514: pay_assignment_actions paa
6515: where pai.locked_action_id = c_cur_asg_action_id
6516: and ppa.action_type in ('P','U')
6517: and paa.payroll_action_id = ppa.payroll_action_id

Line 6526: pay_payroll_actions ppa

6522: SELECT paa.assignment_action_id,
6523: ppa.payroll_action_id,
6524: ppa.effective_date
6525: FROM pay_assignment_actions paa,
6526: pay_payroll_actions ppa
6527: WHERE paa.assignment_id = p_asgid
6528: AND ppa.payroll_action_id = p_pre_pay_id
6529: AND paa.payroll_action_id = ppa.payroll_action_id;
6530:

Line 6534: FROM pay_payroll_actions ppa2

6530:
6531: CURSOR get_first_fps_date(c_payroll_id number)
6532: IS
6533: SELECT max (ppa2.effective_date)
6534: FROM pay_payroll_actions ppa2
6535: WHERE ppa2.report_qualifier = 'GB'
6536: AND ppa2.report_type = 'RTI_FPS_REP'
6537: AND ppa2.action_status = 'C'
6538: AND substr (pay_gb_eoy_archive.get_parameter (ppa2.legislative_parameters,'FIRST_FPS'),1,20) = 'Y'

Line 6566: pay_payroll_actions ppa

6562: cursor csr_ni_prepay_asg_act_details(c_payroll_asg_act_id number) is
6563: select pai.locking_action_id prepay_asg_act_id from
6564: pay_action_interlocks pai,
6565: pay_assignment_actions paa,
6566: pay_payroll_actions ppa
6567: where pai.locked_action_id = c_payroll_asg_act_id
6568: and pai.locking_action_id = paa.assignment_action_id
6569: and paa.action_status in ('C','S')
6570: and ppa.action_type in ('P','U')

Line 6576: pay_payroll_actions ppa

6572:
6573: -- to check whether the given assignment is processed in given prepay payroll_action id
6574: cursor csr_rti_rpt_proc_prepay(c_ni_rpt_asg_id number,c_pre_pay_action_id number) is
6575: select 'Y' from pay_assignment_actions paa,
6576: pay_payroll_actions ppa
6577: where
6578: ppa.payroll_action_id = c_pre_pay_action_id
6579: and ppa.payroll_action_id = paa.payroll_action_id
6580: and paa.assignment_id = c_ni_rpt_asg_id

Line 6600: pay_payroll_actions pact,

6596: IS
6597: SELECT count(distinct paa1.assignment_id)
6598: FROM pay_assignment_actions paa,
6599: per_all_assignments_f paaf,
6600: pay_payroll_actions pact,
6601: per_time_periods ptp,
6602: pay_assignment_actions paa1, --Prepayments
6603: pay_payroll_actions ppa1, --Prepayments
6604: pay_action_interlocks pai --Prepayments

Line 6603: pay_payroll_actions ppa1, --Prepayments

6599: per_all_assignments_f paaf,
6600: pay_payroll_actions pact,
6601: per_time_periods ptp,
6602: pay_assignment_actions paa1, --Prepayments
6603: pay_payroll_actions ppa1, --Prepayments
6604: pay_action_interlocks pai --Prepayments
6605: WHERE paa.assignment_id = paaf.assignment_id
6606: AND paaf.person_id = p_person_id
6607: AND paa.payroll_action_id = pact.payroll_action_id

Line 6621: FROM pay_payroll_actions appa, --Payroll Run

6617:
6618: CURSOR csr_aggr_max_act_id( p_person_id NUMBER)
6619: IS
6620: SELECT max(act.assignment_action_id) assignment_action_id
6621: FROM pay_payroll_actions appa, --Payroll Run
6622: pay_payroll_actions appa2, --Prepayments
6623: pay_assignment_actions act, --Payroll Run
6624: pay_assignment_actions act1, --Prepayments
6625: pay_action_interlocks pai, --Prepayments

Line 6622: pay_payroll_actions appa2, --Prepayments

6618: CURSOR csr_aggr_max_act_id( p_person_id NUMBER)
6619: IS
6620: SELECT max(act.assignment_action_id) assignment_action_id
6621: FROM pay_payroll_actions appa, --Payroll Run
6622: pay_payroll_actions appa2, --Prepayments
6623: pay_assignment_actions act, --Payroll Run
6624: pay_assignment_actions act1, --Prepayments
6625: pay_action_interlocks pai, --Prepayments
6626: per_all_assignments_f as1,

Line 7283: FROM pay_payroll_actions

7279: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYROLL_ID'),1,20) payroll_id,
7280: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
7281: SUBSTR(pay_gb_eoy_archive.get_parameter (legislative_parameters, 'FIRST_FPS'), 1,1) first_fps
7282:
7283: FROM pay_payroll_actions
7284: WHERE payroll_action_id = p_payroll_action_id;
7285:
7286: cursor csr_prepayment_date(pre_pay_id number)
7287: is

Line 7291: pay_payroll_actions ppa

7287: is
7288: SELECT
7289: ppa.effective_date
7290: FROM
7291: pay_payroll_actions ppa
7292: WHERE
7293: ppa.payroll_action_id = pre_pay_id;
7294:
7295: CURSOR csr_pre_pact_eff_date(p_payroll_action_id NUMBER)

Line 7298: FROM pay_payroll_actions

7294:
7295: CURSOR csr_pre_pact_eff_date(p_payroll_action_id NUMBER)
7296: IS
7297: SELECT effective_date
7298: FROM pay_payroll_actions
7299: WHERE payroll_action_id = p_payroll_action_id;
7300:
7301: CURSOR csr_payroll_details(pactid NUMBER)
7302: IS

Line 7312: FROM pay_payroll_actions pact,

7308: lpad(NVL(SUBSTR(hoi.org_information1,1,3),' '),3,0) tax_office_no,
7309: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
7310: NVL(upper(SUBSTR(hoi.org_information6,1,13)),' ') acc_ref_no,
7311: report_type
7312: FROM pay_payroll_actions pact,
7313: hr_organization_information hoi
7314: WHERE pact.payroll_action_id =pactid
7315: AND pact.business_group_id = hoi.organization_id
7316: AND hoi.org_information_context = 'Tax Details References'

Line 7431: FROM pay_payroll_actions ppa2

7427:
7428: CURSOR get_first_fps_date(c_payroll_id number)
7429: IS
7430: SELECT max (ppa2.effective_date)
7431: FROM pay_payroll_actions ppa2
7432: WHERE ppa2.report_qualifier = 'GB'
7433: AND ppa2.report_type = 'RTI_FPS_REP'
7434: AND ppa2.action_status = 'C'
7435: AND substr (pay_gb_eoy_archive.get_parameter (ppa2.legislative_parameters,'FIRST_FPS'),1,20) = 'Y'

Line 7953: ,pay_payroll_actions pact

7949: || paa.assignment_action_id),16)) max_asg_act_id
7950: , max(pact.effective_date) effective_date
7951:
7952: FROM pay_assignment_actions paa
7953: ,pay_payroll_actions pact
7954: ,per_time_periods ptp
7955: WHERE paa.assignment_id = c_asg_id
7956: AND paa.payroll_action_id = pact.payroll_action_id
7957: AND pact.time_period_id = ptp.time_period_id

Line 7972: ,pay_payroll_actions pact

7968: || paa.assignment_action_id),16)) max_asg_act_id
7969: , max(pact.effective_date) effective_date
7970:
7971: FROM pay_assignment_actions paa
7972: ,pay_payroll_actions pact
7973: ,per_time_periods ptp
7974: WHERE paa.assignment_id = c_asg_id
7975: AND paa.payroll_action_id = pact.payroll_action_id
7976: AND pact.time_period_id = ptp.time_period_id

Line 8136: FROM pay_payroll_actions ppa,

8132: --Below cursor fetches the payment date for the payroll run of the current assignment
8133: CURSOR csr_get_payment_date(p_last_asg_action_id NUMBER)
8134: IS
8135: SELECT ptp.regular_payment_date payment_date
8136: FROM pay_payroll_actions ppa,
8137: pay_assignment_actions paa,
8138: per_time_periods ptp
8139: WHERE assignment_action_id = p_last_asg_action_id
8140: AND ppa.time_period_id = ptp.time_period_id

Line 8167: pay_payroll_actions ppa

8163: asg.person_id,
8164: asg.assignment_number
8165: FROM per_all_assignments_f asg,
8166: pay_assignment_actions paa,
8167: pay_payroll_actions ppa
8168: WHERE paa.assignment_action_id = c_asg_act_id
8169: AND paa.assignment_id = asg.assignment_id
8170: AND ppa.payroll_action_id = g_pre_pact_id
8171: AND ppa.effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line 8203: pay_payroll_actions pact,

8199: to_number(SUBSTR(MAX(lpad(paa.action_sequence,15,'0')
8200: || paa.assignment_action_id),16)) max_asg_act_id,
8201: MAX(pact.effective_date) effective_date
8202: FROM pay_assignment_actions paa,
8203: pay_payroll_actions pact,
8204: per_time_periods ptp,
8205: pay_assignment_actions paa1, --Prepayments
8206: pay_payroll_actions ppa1, --Prepayments
8207: pay_action_interlocks pai --Prepayments

Line 8206: pay_payroll_actions ppa1, --Prepayments

8202: FROM pay_assignment_actions paa,
8203: pay_payroll_actions pact,
8204: per_time_periods ptp,
8205: pay_assignment_actions paa1, --Prepayments
8206: pay_payroll_actions ppa1, --Prepayments
8207: pay_action_interlocks pai --Prepayments
8208: WHERE paa.assignment_id = p_asgid
8209: AND paa.payroll_action_id = pact.payroll_action_id
8210: AND pact.time_period_id = ptp.time_period_id

Line 8229: pay_payroll_actions pact,

8225: to_number(SUBSTR(MAX(lpad(paa.action_sequence,15,'0')
8226: || paa.assignment_action_id),16)) max_asg_act_id,
8227: MAX(pact.effective_date) effective_date
8228: FROM pay_assignment_actions paa,
8229: pay_payroll_actions pact,
8230: per_time_periods ptp,
8231: pay_assignment_actions paa1, --Prepayments
8232: pay_payroll_actions ppa1, --Prepayments
8233: pay_action_interlocks pai --Prepayments

Line 8232: pay_payroll_actions ppa1, --Prepayments

8228: FROM pay_assignment_actions paa,
8229: pay_payroll_actions pact,
8230: per_time_periods ptp,
8231: pay_assignment_actions paa1, --Prepayments
8232: pay_payroll_actions ppa1, --Prepayments
8233: pay_action_interlocks pai --Prepayments
8234: WHERE paa.assignment_id = p_asgid --46959
8235: AND paa.payroll_action_id = pact.payroll_action_id
8236: AND pact.time_period_id = ptp.time_period_id

Line 8255: pay_payroll_actions ppa

8251: SELECT paa.assignment_action_id,
8252: ppa.payroll_action_id,
8253: ppa.effective_date
8254: FROM pay_assignment_actions paa,
8255: pay_payroll_actions ppa
8256: WHERE paa.assignment_id = p_asgid
8257: AND ppa.payroll_action_id = p_pre_pay_id
8258: AND paa.payroll_action_id = ppa.payroll_action_id;
8259: ---

Line 8334: pay_payroll_actions ppa

8330: pay_personal_payment_methods_f pppf,
8331: pay_external_accounts Orgkey,
8332: pay_external_accounts deskey,
8333: PAY_ASSIGNMENT_ACTIONS PAA,
8334: pay_payroll_actions ppa
8335: WHERE popf.ORG_PAYMENT_METHOD_ID = ppp.ORG_PAYMENT_METHOD_ID
8336: AND pppf.personal_payment_method_ID = ppp.personal_payment_method_ID
8337: AND popf.PAYMENT_TYPE_ID = ppt.PAYMENT_TYPE_ID
8338: AND ppt.PAYMENT_TYPE_NAME = 'BACS Tape'

Line 8355: pay_payroll_actions ppa

8351: select (sum(ppp.value) * 100) amount
8352: from pay_pre_payments ppp,
8353: pay_org_payment_methods_f popmf,
8354: pay_assignment_actions paa,
8355: pay_payroll_actions ppa
8356: where ppp.ASSIGNMENT_ACTION_ID = c_prepay_asg_action_id
8357: and popmf.ORG_PAYMENT_METHOD_ID = ppp.ORG_PAYMENT_METHOD_ID
8358: and popmf.defined_balance_id is not null
8359: and ppa.payroll_action_id = paa.payroll_action_id

Line 8378: pay_payroll_actions pact,

8374: || paa.assignment_action_id),16)) max_asg_act_id,
8375: MAX(pact.effective_date) effective_date
8376: FROM pay_assignment_actions paa,
8377: per_all_assignments_f paaf,
8378: pay_payroll_actions pact,
8379: per_time_periods ptp,
8380: pay_assignment_actions paa1, --Prepayments
8381: pay_payroll_actions ppa1, --Prepayments
8382: pay_action_interlocks pai --Prepayments

Line 8381: pay_payroll_actions ppa1, --Prepayments

8377: per_all_assignments_f paaf,
8378: pay_payroll_actions pact,
8379: per_time_periods ptp,
8380: pay_assignment_actions paa1, --Prepayments
8381: pay_payroll_actions ppa1, --Prepayments
8382: pay_action_interlocks pai --Prepayments
8383: WHERE paa.assignment_id = paaf.assignment_id
8384: AND paaf.person_id = p_person_id
8385: AND paa.payroll_action_id = pact.payroll_action_id

Line 8419: ,pay_payroll_actions pact

8415: || paa.assignment_action_id),16)) max_asg_act_id
8416: ,max (pact.effective_date) effective_date
8417: FROM pay_assignment_actions paa
8418: ,per_all_assignments_f paaf
8419: ,pay_payroll_actions pact
8420: ,per_time_periods ptp
8421: WHERE paa.assignment_id = paaf.assignment_id
8422: AND paaf.person_id = p_person_id
8423: AND paa.payroll_action_id = pact.payroll_action_id

Line 8468: ,pay_payroll_actions pact

8464: (select null
8465: */
8466: SELECT min (act.assignment_action_id)
8467: FROM pay_action_classifications class
8468: ,pay_payroll_actions pact
8469: ,pay_assignment_actions act
8470: ,per_all_assignments_f ass
8471: ,per_periods_of_service pos
8472: WHERE pos.person_id = p_person_id

Line 8487: pay_payroll_actions ppa

8483: IS
8484: SELECT 'Y' this_prepayment
8485: FROM pay_action_interlocks pai,
8486: pay_assignment_actions paa,
8487: pay_payroll_actions ppa
8488: WHERE paa.payroll_action_id = ppa.payroll_action_id
8489: AND paa.assignment_action_id = pai.locking_action_id
8490: AND ppa.action_type in ('P','U')
8491: AND ppa.payroll_action_id = g_pre_pact_id

Line 8578: pay_payroll_actions ppa

8574: cursor csr_asg_act_oth_asgs(c_asg_id number) is
8575: select max(paa.assignment_action_id) asg_act_id from per_all_assignments_f paaf,
8576: per_all_assignments_f paaf1,
8577: pay_assignment_actions paa,
8578: pay_payroll_actions ppa
8579: where paaf.assignment_id = c_asg_id
8580: and paaf1.person_id = paaf.person_id
8581: and paaf1.assignment_id <> c_asg_id
8582: and paaf1.assignment_id = paa.assignment_id

Line 8609: FROM pay_payroll_actions pact

8605: -- To fetch First FPS parameter
8606: /*CURSOR csr_parameter_info IS
8607: SELECT substr (pay_gb_eoy_archive.get_parameter (legislative_parameters, 'FIRST_FPS'), 1,1) first_fps,
8608: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref
8609: FROM pay_payroll_actions pact
8610: , pay_assignment_actions paa
8611: WHERE paa.assignment_action_id = p_assactid
8612: AND pact.payroll_action_id = paa.payroll_action_id;
8613: */

Line 8638: , pay_payroll_actions pact

8634: , '0')
8635: || paa.assignment_action_id), 16))
8636: , max (pact.effective_date) effective_date
8637: FROM pay_assignment_actions paa
8638: , pay_payroll_actions pact
8639: , per_time_periods ptp
8640: WHERE paa.assignment_id = p_asgid
8641: AND paa.payroll_action_id = pact.payroll_action_id
8642: AND pact.payroll_id = l_payroll

Line 8661: , pay_payroll_actions pact

8657: , '0')
8658: || paa.assignment_action_id), 16))
8659: , max (pact.effective_date) effective_date
8660: FROM pay_assignment_actions paa
8661: , pay_payroll_actions pact
8662: , per_time_periods ptp
8663: WHERE paa.assignment_id = p_asgid
8664: AND paa.payroll_action_id = pact.payroll_action_id
8665: AND pact.time_period_id = ptp.time_period_id

Line 8701: pay_payroll_actions ppa1, --Prepayments

8697:
8698: cursor csr_chk_prepayment_run(c_assignment_action_id number) is
8699: select count(*) from pay_assignment_actions paa, --run
8700: pay_assignment_actions paa1, --Prepayments
8701: pay_payroll_actions ppa1, --Prepayments
8702: pay_action_interlocks pai --Prepayments
8703: where paa.assignment_action_id = c_assignment_action_id --9917796
8704: AND paa.assignment_action_id = pai.locked_action_id
8705: AND paa1.assignment_action_id = pai.locking_action_id

Line 8716: FROM pay_payroll_actions ppa, --Current pactid

8712: IS
8713:
8714: SELECT count(distinct act.assignment_action_id),
8715: min(act.assignment_action_id) assignment_action_id
8716: FROM pay_payroll_actions ppa, --Current pactid
8717: pay_payroll_actions appa, --Payroll Run
8718: pay_payroll_actions appa2, --Prepayments
8719: pay_assignment_actions act, --Payroll Run
8720: pay_assignment_actions act1, --Prepayments

Line 8717: pay_payroll_actions appa, --Payroll Run

8713:
8714: SELECT count(distinct act.assignment_action_id),
8715: min(act.assignment_action_id) assignment_action_id
8716: FROM pay_payroll_actions ppa, --Current pactid
8717: pay_payroll_actions appa, --Payroll Run
8718: pay_payroll_actions appa2, --Prepayments
8719: pay_assignment_actions act, --Payroll Run
8720: pay_assignment_actions act1, --Prepayments
8721: pay_action_interlocks pai, --Prepayments

Line 8718: pay_payroll_actions appa2, --Prepayments

8714: SELECT count(distinct act.assignment_action_id),
8715: min(act.assignment_action_id) assignment_action_id
8716: FROM pay_payroll_actions ppa, --Current pactid
8717: pay_payroll_actions appa, --Payroll Run
8718: pay_payroll_actions appa2, --Prepayments
8719: pay_assignment_actions act, --Payroll Run
8720: pay_assignment_actions act1, --Prepayments
8721: pay_action_interlocks pai, --Prepayments
8722: per_all_assignments_f as1

Line 8743: FROM pay_payroll_actions ppa, --Current pactid

8739: p_pre_pact_id NUMBER)
8740: IS
8741:
8742: SELECT max(act.assignment_action_id) assignment_action_id
8743: FROM pay_payroll_actions ppa, --Current pactid
8744: pay_payroll_actions appa, --Payroll Run
8745: pay_payroll_actions appa2, --Prepayments
8746: pay_assignment_actions act, --Payroll Run
8747: pay_assignment_actions act1, --Prepayments

Line 8744: pay_payroll_actions appa, --Payroll Run

8740: IS
8741:
8742: SELECT max(act.assignment_action_id) assignment_action_id
8743: FROM pay_payroll_actions ppa, --Current pactid
8744: pay_payroll_actions appa, --Payroll Run
8745: pay_payroll_actions appa2, --Prepayments
8746: pay_assignment_actions act, --Payroll Run
8747: pay_assignment_actions act1, --Prepayments
8748: pay_action_interlocks pai, --Prepayments

Line 8745: pay_payroll_actions appa2, --Prepayments

8741:
8742: SELECT max(act.assignment_action_id) assignment_action_id
8743: FROM pay_payroll_actions ppa, --Current pactid
8744: pay_payroll_actions appa, --Payroll Run
8745: pay_payroll_actions appa2, --Prepayments
8746: pay_assignment_actions act, --Payroll Run
8747: pay_assignment_actions act1, --Prepayments
8748: pay_action_interlocks pai, --Prepayments
8749: per_all_assignments_f as1

Line 8769: pay_payroll_actions ppa, --Current pactid

8765: IS
8766: SELECT act.assignment_id assignment_id,
8767: max(act.assignment_action_id) asg_act_id
8768: FROM
8769: pay_payroll_actions ppa, --Current pactid
8770: pay_payroll_actions appa, --Payroll Run
8771: pay_payroll_actions appa2, --Prepayments
8772: pay_assignment_actions act, --Payroll Run
8773: pay_assignment_actions act1, --Prepayments

Line 8770: pay_payroll_actions appa, --Payroll Run

8766: SELECT act.assignment_id assignment_id,
8767: max(act.assignment_action_id) asg_act_id
8768: FROM
8769: pay_payroll_actions ppa, --Current pactid
8770: pay_payroll_actions appa, --Payroll Run
8771: pay_payroll_actions appa2, --Prepayments
8772: pay_assignment_actions act, --Payroll Run
8773: pay_assignment_actions act1, --Prepayments
8774: pay_action_interlocks pai, --Prepayments

Line 8771: pay_payroll_actions appa2, --Prepayments

8767: max(act.assignment_action_id) asg_act_id
8768: FROM
8769: pay_payroll_actions ppa, --Current pactid
8770: pay_payroll_actions appa, --Payroll Run
8771: pay_payroll_actions appa2, --Prepayments
8772: pay_assignment_actions act, --Payroll Run
8773: pay_assignment_actions act1, --Prepayments
8774: pay_action_interlocks pai, --Prepayments
8775: per_all_assignments_f as1

Line 8808: FROM pay_payroll_actions ppa, --Current pactid

8804: IS
8805:
8806: SELECT count(distinct act.assignment_action_id),
8807: max(act.assignment_action_id) assignment_action_id
8808: FROM pay_payroll_actions ppa, --Current pactid
8809: pay_payroll_actions appa, --Payroll Run
8810: pay_payroll_actions appa2, --Prepayments
8811: pay_assignment_actions act, --Payroll Run
8812: pay_assignment_actions act1, --Prepayments

Line 8809: pay_payroll_actions appa, --Payroll Run

8805:
8806: SELECT count(distinct act.assignment_action_id),
8807: max(act.assignment_action_id) assignment_action_id
8808: FROM pay_payroll_actions ppa, --Current pactid
8809: pay_payroll_actions appa, --Payroll Run
8810: pay_payroll_actions appa2, --Prepayments
8811: pay_assignment_actions act, --Payroll Run
8812: pay_assignment_actions act1, --Prepayments
8813: pay_action_interlocks pai, --Prepayments

Line 8810: pay_payroll_actions appa2, --Prepayments

8806: SELECT count(distinct act.assignment_action_id),
8807: max(act.assignment_action_id) assignment_action_id
8808: FROM pay_payroll_actions ppa, --Current pactid
8809: pay_payroll_actions appa, --Payroll Run
8810: pay_payroll_actions appa2, --Prepayments
8811: pay_assignment_actions act, --Payroll Run
8812: pay_assignment_actions act1, --Prepayments
8813: pay_action_interlocks pai, --Prepayments
8814: per_all_assignments_f as1

Line 8983: pay_payroll_actions ppa,

8979: cursor chk_processed_in_prepay(c_cur_asg_action_id number) is
8980: select pai.locking_action_id
8981: from
8982: pay_action_interlocks pai,
8983: pay_payroll_actions ppa,
8984: pay_assignment_actions paa
8985: where pai.locked_action_id = c_cur_asg_action_id
8986: and ppa.action_type in ('P','U')
8987: and paa.payroll_action_id = ppa.payroll_action_id

Line 8993: pay_payroll_actions ppa,

8989:
8990: /* cursor csr_is_retry_request is
8991: select 'Y' from fnd_concurrent_programs fcp,
8992: fnd_concurrent_requests fcr,
8993: pay_payroll_actions ppa,
8994: pay_assignment_actions paa
8995: where paa.assignment_action_id = p_assactid
8996: and ppa.payroll_action_id = paa.payroll_action_id
8997: and ppa.request_id = fcr.request_id

Line 9020: pay_payroll_actions ppa

9016:
9017: -- to check whether the given assignment is processed in given prepay payroll_action id
9018: cursor csr_rti_rpt_proc_prepay(c_ni_rpt_asg_id number,c_pre_pay_action_id number) is
9019: select 'Y' from pay_assignment_actions paa,
9020: pay_payroll_actions ppa
9021: where
9022: ppa.payroll_action_id = c_pre_pay_action_id
9023: and ppa.payroll_action_id = paa.payroll_action_id
9024: and paa.assignment_id = c_ni_rpt_asg_id

Line 9037: ,pay_payroll_actions pact

9033: || paa.assignment_action_id),16)) max_asg_act_id
9034: , max(pact.effective_date) effective_date
9035:
9036: FROM pay_assignment_actions paa
9037: ,pay_payroll_actions pact
9038: ,per_time_periods ptp
9039: WHERE paa.assignment_id = c_asg_id
9040: AND paa.payroll_action_id = pact.payroll_action_id
9041: AND pact.time_period_id = ptp.time_period_id

Line 9059: pay_payroll_actions pact,

9055: IS
9056: SELECT count(distinct paa1.assignment_id)
9057: FROM pay_assignment_actions paa,
9058: per_all_assignments_f paaf,
9059: pay_payroll_actions pact,
9060: per_time_periods ptp,
9061: pay_assignment_actions paa1, --Prepayments
9062: pay_payroll_actions ppa1, --Prepayments
9063: pay_action_interlocks pai --Prepayments

Line 9062: pay_payroll_actions ppa1, --Prepayments

9058: per_all_assignments_f paaf,
9059: pay_payroll_actions pact,
9060: per_time_periods ptp,
9061: pay_assignment_actions paa1, --Prepayments
9062: pay_payroll_actions ppa1, --Prepayments
9063: pay_action_interlocks pai --Prepayments
9064: WHERE paa.assignment_id = paaf.assignment_id
9065: AND paaf.person_id = p_person_id
9066: AND paa.payroll_action_id = pact.payroll_action_id

Line 9081: FROM pay_payroll_actions pact,

9077: -- To fetch First FPS parameter
9078: CURSOR csr_parameter_info IS
9079: SELECT fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date,
9080: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id
9081: FROM pay_payroll_actions pact,
9082: pay_assignment_actions paa
9083: WHERE paa.assignment_action_id = p_assactid
9084: AND pact.payroll_action_id = paa.payroll_action_id;
9085:

Line 9096: , pay_payroll_actions pact

9092: , max (pact.effective_date) effective_date
9093:
9094: FROM per_all_assignments_f paaf,
9095: pay_assignment_actions paa
9096: , pay_payroll_actions pact
9097: , per_time_periods ptp
9098: WHERE paa.assignment_id = paaf.assignment_id
9099: and paaf.person_id = person_id
9100: AND paa.payroll_action_id = pact.payroll_action_id

Line 9140: pay_payroll_actions ppa

9136:
9137: cursor csr_fps_check(p_asg_id number) is
9138: select count(*)
9139: from pay_assignment_actions paa,
9140: pay_payroll_actions ppa
9141: where paa.assignment_id = p_asg_id
9142: and paa.action_status ='C'
9143: and paa.assignment_action_id <> p_assactid
9144: and ppa.payroll_action_id = paa.payroll_action_id

Line 10313: pay_payroll_actions ppa,

10309: l_payroll_asg_acts(l_tab_counter) := l_cur_asg_action_id;
10310: begin
10311: select ppa.payroll_action_id into l_oth_min_pre_pay_id from
10312: pay_action_interlocks pai,
10313: pay_payroll_actions ppa,
10314: pay_assignment_actions paa
10315: where
10316: pai.locked_action_id = l_cur_asg_action_id
10317: and pai.locking_action_id = paa.assignment_action_id

Line 12229: select * from pay_payroll_actions ppa,

12225: end if;
12226: hr_utility.set_location('record_count: ' || record_count ,1000);
12227: /* else -- else for l_archive_tab_ni_rpt.count > 0
12228: -- get the latest prepayment and the payroll details.
12229: select * from pay_payroll_actions ppa,
12230: get_ni_only_asg_details(l_ni_rpt_asg_id,l_archive_tab_ni_rpt,
12231: end if; -- end if for l_archive_tab_ni_rpt.count > 0
12232: */
12233:

Line 12351: FROM pay_payroll_actions pact

12347: l_error_flag VARCHAR2(1);
12348: CURSOR csr_is_etext_report
12349: IS
12350: SELECT report_type
12351: FROM pay_payroll_actions pact
12352: WHERE pact.payroll_action_id = pactid;
12353: l_is_etext_report VARCHAR2(50);
12354: l_request_id fnd_concurrent_requests.request_id%TYPE;
12355: xml_layout BOOLEAN;

Line 12376: FROM pay_payroll_actions pact,

12372: hoi.org_information7 econ_number,
12373: pact.business_group_id bus_grp_id,
12374: pact.action_parameter_group_id act_param_grp_id,
12375: org_information19 service_company
12376: FROM pay_payroll_actions pact,
12377: hr_organization_information hoi
12378: WHERE pact.payroll_action_id =pactid
12379: AND pact.business_group_id = hoi.organization_id
12380: AND hoi.org_information_context = 'Tax Details References'

Line 12403: FROM pay_payroll_actions

12399: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'P11D_DUE'),1,20) p11d_due,
12400: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'HMRC_ADVAN'),1,20) hmrc_advance_received,
12401: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'CIS_DEDUCT'),1,20) cis_deductions,
12402: substr(legislative_parameters,instr(legislative_parameters,'VERSION=')+8) version
12403: FROM pay_payroll_actions
12404: WHERE payroll_action_id = pactid;
12405:
12406: l_payroll_rec csr_payroll_details%rowtype;
12407: l_action_info_id NUMBER(15);

Line 12440: FROM pay_payroll_actions pact

12436: SELECT legislative_parameters para,
12437: fnd_number.number_to_canonical(request_id) control_id,
12438: report_type,
12439: business_group_id
12440: FROM pay_payroll_actions pact
12441: WHERE payroll_action_id = pactid;
12442:
12443: CURSOR csr_header_det(p_bus_id NUMBER, p_tax_ref VARCHAR2)
12444: IS

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

12454:
12455: CURSOR csr_payroll_details
12456: IS
12457: SELECT ppf.PAYROLL_NAME , ppapre.EFFECTIVE_DATE
12458: from pay_payrolls_f ppf,pay_payroll_actions ppapre,pay_payroll_actions ppa
12459: WHERE ppa.payroll_action_id = pactid
12460: and ppf.payroll_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PAYROLL_ID'),1,20)
12461: and ppapre.payroll_action_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PRE_PAY_ID'),1,20);
12462:

Line 12468: FROM pay_payroll_actions ppa,

12464: CURSOR get_asg_action_id_error
12465: IS
12466: SELECT DISTINCT paa.assignment_action_id asg_action_id,
12467: assignment_id
12468: FROM pay_payroll_actions ppa,
12469: pay_assignment_actions paa
12470: WHERE ppa.payroll_action_id = pactid -- pact_id
12471: AND paa.payroll_action_id = ppa.payroll_action_id
12472: AND paa.action_status = 'E';

Line 12636: FROM pay_payroll_actions ppa,

12632: CURSOR get_asg_action_id
12633: IS
12634: SELECT DISTINCT paa.assignment_action_id asg_action_id,
12635: assignment_id
12636: FROM pay_payroll_actions ppa,
12637: pay_assignment_actions paa
12638: WHERE ppa.payroll_action_id = pactid -- pact_id
12639: AND paa.payroll_action_id = ppa.payroll_action_id
12640: AND paa.action_status = 'C';

Line 12647: FROM pay_payroll_actions ppa,

12643: CURSOR get_asg_action_id_error
12644: IS
12645: SELECT DISTINCT paa.assignment_action_id asg_action_id,
12646: assignment_id
12647: FROM pay_payroll_actions ppa,
12648: pay_assignment_actions paa
12649: WHERE ppa.payroll_action_id = pactid -- pact_id
12650: AND paa.payroll_action_id = ppa.payroll_action_id
12651: AND paa.action_status = 'E';

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

12705: AND message_level = 'W'
12706: AND payroll_id = 100;
12707:
12708: cursor csr_get_prepayment_date(p_pre_pact_id number) is
12709: select EFFECTIVE_DATE from pay_payroll_actions where payroll_action_id = p_pre_pact_id;
12710:
12711: err_msg varchar2(255);--csr_err_msg%rowtype;
12712: et_asg_rec get_person_details%rowtype;
12713: asg_rec get_person_details%rowtype;

Line 12842: FROM pay_payroll_actions ppa,

12838:
12839: CURSOR get_person_count
12840: IS
12841: SELECT COUNT(DISTINCT(paaf.person_id))
12842: FROM pay_payroll_actions ppa,
12843: pay_assignment_actions paa,
12844: per_all_assignments_f paaf
12845: WHERE ppa.payroll_action_id = pactid -- pact_id
12846: AND paa.payroll_action_id = ppa.payroll_action_id