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_ASSIGNMENT_ACTIONS

Line 1258: FROM pay_assignment_actions act,

1254: pap.date_of_birth date_of_birth,
1255: SUBSTR(pap.sex,1,1) sex ,
1256: DECODE(pap.per_information10,'Y','Y',NULL) agg_paye_flag,
1257: DECODE(pap.per_information9,'Y','Y',NULL) multiple_asg_flag
1258: FROM pay_assignment_actions act,
1259: per_all_assignments_f paa,
1260: per_all_people_f pap
1261: WHERE act.assignment_action_id = p_assactid
1262: AND act.assignment_id = paa.assignment_id

Line 1434: pay_assignment_actions paa,

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

Line 1472: FROM pay_assignment_actions paa ,

1468: --Below cursor fetches further ni details of the current assignment
1469: CURSOR csr_cat_NI_Details
1470: IS
1471: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
1472: FROM pay_assignment_actions paa ,
1473: pay_run_results prr,
1474: pay_run_result_values prrv,
1475: pay_element_types_f petf ,
1476: pay_input_values_f pivf

Line 1490: FROM pay_assignment_actions paa ,

1486: --Below cursor fetches further ni details of the current assignment
1487: CURSOR csr_cat_NI
1488: IS
1489: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
1490: FROM pay_assignment_actions paa ,
1491: pay_run_results prr,
1492: pay_run_result_values prrv,
1493: pay_element_types_f petf ,
1494: pay_input_values_f pivf

Line 1512: pay_assignment_actions paa

1508: trim(NVL(pap.per_information10,'N')) per_agg_flag,
1509: asg.assignment_number assignment_number
1510: FROM per_all_people_f pap,
1511: per_all_assignments_f asg,
1512: pay_assignment_actions paa
1513: WHERE paa.assignment_action_id = c_asg_act_id
1514: AND paa.assignment_id = asg.assignment_id
1515: AND pap.person_id = asg.person_id
1516: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 1532: FROM pay_assignment_actions paa,

1528: SELECT
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

Line 1535: pay_assignment_actions paa1, --Prepayments

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
1538: WHERE paa.assignment_id = p_asgid
1539: AND paa.payroll_action_id = pact.payroll_action_id

Line 1590: pay_assignment_actions paa_max

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')
1594: and ppa_max.payroll_action_id = paa_max.payroll_action_id

Line 1601: from pay_assignment_actions paa_prepay,

1597: --Below cursor fetches the Previous run FPS assignment_action_id
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

Line 1603: pay_assignment_actions paa_fps,

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
1607: and ppa_prepay.payroll_action_id = paa_prepay.payroll_action_id

Line 2252: pay_assignment_actions paa,

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

Line 2285: FROM pay_assignment_actions paa ,

2281: --Below cursor fetches further ni details of the current assignment
2282: CURSOR csr_cat_NI_Details
2283: IS
2284: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
2285: FROM pay_assignment_actions paa ,
2286: pay_run_results prr,
2287: pay_run_result_values prrv,
2288: pay_element_types_f petf ,
2289: pay_input_values_f pivf

Line 2303: FROM pay_assignment_actions paa ,

2299: --Below cursor fetches further ni details of the current assignment
2300: CURSOR csr_cat_NI
2301: IS
2302: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
2303: FROM pay_assignment_actions paa ,
2304: pay_run_results prr,
2305: pay_run_result_values prrv,
2306: pay_element_types_f petf ,
2307: pay_input_values_f pivf

Line 2340: FROM pay_assignment_actions paa,

2336: SELECT
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

Line 2343: pay_assignment_actions paa1, --Prepayments

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
2346: WHERE paa.assignment_id = p_asgid
2347: AND paa.payroll_action_id = pact.payroll_action_id

Line 2398: pay_assignment_actions paa_max

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')
2402: and ppa_max.payroll_action_id = paa_max.payroll_action_id

Line 2409: from pay_assignment_actions paa_prepay,

2405: --Below cursor fetches the Previous run FPS assignment_action_id
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

Line 2411: pay_assignment_actions paa_fps,

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
2415: and ppa_prepay.payroll_action_id = paa_prepay.payroll_action_id

Line 2456: pay_assignment_actions paa,

2452: to_number(SUBSTR(MAX(lpad(paa.action_sequence,15,'0')
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

Line 2459: pay_assignment_actions paa1, --Prepayments

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
2462: WHERE paaf.person_id = p_person_rec.person_id--59437
2463: AND sysdate between paaf.effective_start_date and paaf.effective_end_date

Line 3065: pay_assignment_actions paa,

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

Line 3097: FROM pay_assignment_actions paa ,

3093: --Below cursor fetches further ni details of the current assignment
3094: CURSOR csr_cat_NI_Details
3095: IS
3096: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
3097: FROM pay_assignment_actions paa ,
3098: pay_run_results prr,
3099: pay_run_result_values prrv,
3100: pay_element_types_f petf ,
3101: pay_input_values_f pivf

Line 3113: FROM pay_assignment_actions paa ,

3109: --Below cursor fetches further ni details of the current assignment
3110: CURSOR csr_cat_NI
3111: IS
3112: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
3113: FROM pay_assignment_actions paa ,
3114: pay_run_results prr,
3115: pay_run_result_values prrv,
3116: pay_element_types_f petf ,
3117: pay_input_values_f pivf

Line 3134: pay_assignment_actions paa

3130: asg.assignment_number assignment_number,
3131: asg.assignment_id assignment_id
3132: FROM per_all_people_f pap,
3133: per_all_assignments_f asg,
3134: pay_assignment_actions paa
3135: WHERE paa.assignment_action_id = c_asg_act_id
3136: AND paa.assignment_id = asg.assignment_id
3137: AND pap.person_id = asg.person_id
3138: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 3154: FROM pay_assignment_actions paa,

3150: SELECT
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

Line 3157: pay_assignment_actions paa1, --Prepayments

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
3160: WHERE paa.assignment_id = p_asgid
3161: AND paa.payroll_action_id = pact.payroll_action_id

Line 3212: pay_assignment_actions paa_max

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')
3216: and ppa_max.payroll_action_id = paa_max.payroll_action_id

Line 3223: from pay_assignment_actions paa_prepay,

3219: --Below cursor fetches the Previous run FPS assignment_action_id
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

Line 3225: pay_assignment_actions paa_fps,

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
3229: and ppa_prepay.payroll_action_id = paa_prepay.payroll_action_id

Line 4007: FROM pay_assignment_actions

4003:
4004: CURSOR csr_child_act_id(c_lst_act_id NUMBER) -- kvinayku
4005: IS
4006: SELECT NVL(MAX(ASSIGNMENT_ACTION_ID),c_lst_act_id)
4007: FROM pay_assignment_actions
4008: WHERE SOURCE_ACTION_ID = c_lst_act_id;
4009:
4010: CURSOR csr_tax_paye_result(p_action_id NUMBER) -- kvinayku
4011: IS

Line 4269: FROM pay_assignment_actions

4265:
4266: CURSOR csr_child_act_id(c_lst_act_id NUMBER) -- kvinayku
4267: IS
4268: SELECT NVL(MAX(ASSIGNMENT_ACTION_ID),c_lst_act_id)
4269: FROM pay_assignment_actions
4270: WHERE SOURCE_ACTION_ID = c_lst_act_id;
4271:
4272: CURSOR csr_tax_paye_result(p_action_id NUMBER) -- kvinayku
4273: IS

Line 4486: FROM pay_assignment_actions

4482:
4483: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
4484: IS
4485: SELECT assignment_action_id
4486: FROM pay_assignment_actions
4487: WHERE source_action_id = c_lst_act_id;
4488:
4489: CURSOR csr_tax_paye_result(p_action_id NUMBER)
4490: IS

Line 4540: FROM pay_assignment_actions

4536:
4537: CURSOR csr_max_child_act_id(c_lst_act_id NUMBER)
4538: IS
4539: SELECT max(assignment_action_id)
4540: FROM pay_assignment_actions
4541: WHERE source_action_id = c_lst_act_id;
4542:
4543: BEGIN
4544: hr_utility.set_location('Entering: '||l_proc,1);

Line 5152: FROM pay_assignment_actions

5148:
5149: CURSOR csr_child_act_id(c_lst_act_id NUMBER)
5150: IS
5151: SELECT ASSIGNMENT_ACTION_ID
5152: FROM pay_assignment_actions
5153: WHERE SOURCE_ACTION_ID = c_lst_act_id;
5154:
5155: CURSOR csr_tax_paye_result(p_action_id NUMBER)
5156: IS

Line 5207: FROM pay_assignment_actions

5203:
5204: CURSOR csr_max_child_act_id(c_lst_act_id NUMBER)
5205: IS
5206: SELECT max(assignment_action_id)
5207: FROM pay_assignment_actions
5208: WHERE source_action_id = c_lst_act_id;
5209:
5210: BEGIN
5211: hr_utility.set_location('Entering: '||l_proc,1);

Line 5947: select paa.assignment_action_id into l_assact_id from pay_assignment_actions paa

5943: ;
5944: hr_utility.trace('action_context_id = '|| p_assactid);
5945: IF p_tab_rec_data(i).action_info_category IS NOT NULL THEN
5946: -- get the assignment action id for the each assignment which are created in action creation
5947: select paa.assignment_action_id into l_assact_id from pay_assignment_actions paa
5948: where paa.payroll_action_id = g_payroll_action_id
5949: and paa.assignment_id = p_tab_rec_data(i).assignment_id;
5950:
5951: pay_action_information_api.create_action_information( p_action_information_id => l_action_id,

Line 6200: pay_assignment_actions act, --Payroll Run

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
6204: WHERE --ppa.payroll_action_id = pactid

Line 6201: pay_assignment_actions act1, --Prepayments

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
6204: WHERE --ppa.payroll_action_id = pactid
6205: as1.person_id BETWEEN stperson AND endperson

Line 6277: FROM pay_assignment_actions paa_pre

6273:
6274: -- cursor to check whether this assignment processed in prepayment or not
6275: cursor csr_prepayment_made(pre_pay_id number,p_asg_id number) is
6276: SELECT paa_pre.assignment_id
6277: FROM pay_assignment_actions paa_pre
6278: , pay_assignment_actions paa_arcv
6279: WHERE paa_arcv.assignment_id = p_asg_id
6280: AND paa_pre.payroll_action_id = pre_pay_id
6281: AND paa_pre.assignment_id = paa_arcv.assignment_id;

Line 6278: , pay_assignment_actions paa_arcv

6274: -- cursor to check whether this assignment processed in prepayment or not
6275: cursor csr_prepayment_made(pre_pay_id number,p_asg_id number) is
6276: SELECT paa_pre.assignment_id
6277: FROM pay_assignment_actions paa_pre
6278: , pay_assignment_actions paa_arcv
6279: WHERE paa_arcv.assignment_id = p_asg_id
6280: AND paa_pre.payroll_action_id = pre_pay_id
6281: AND paa_pre.assignment_id = paa_arcv.assignment_id;
6282:

Line 6304: FROM pay_assignment_actions paa

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

Line 6330: pay_assignment_actions act, --Payroll Run

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

Line 6331: pay_assignment_actions act1, --Prepayments

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

Line 6366: pay_assignment_actions act, --Payroll Run

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

Line 6367: pay_assignment_actions act1, --Prepayments

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

Line 6406: FROM pay_assignment_actions paa

6402: || paa.assignment_action_id),16)) max_asg_act_id*/
6403: distinct paa.assignment_id
6404: /* ,max (pact.effective_date) effective_date
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

Line 6407: ,pay_assignment_actions paa1

6403: distinct paa.assignment_id
6404: /* ,max (pact.effective_date) effective_date
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

Line 6464: FROM pay_assignment_actions paa

6460: || paa.assignment_action_id),16)) max_asg_act_id
6461: ,max(paa.assignment_id)
6462: ,max (pact.effective_date) effective_date*/
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

Line 6465: ,pay_assignment_actions paa1

6461: ,max(paa.assignment_id)
6462: ,max (pact.effective_date) effective_date*/
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

Line 6514: pay_assignment_actions paa

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
6518: and paa.assignment_action_id = pai.locking_action_id;

Line 6525: FROM pay_assignment_actions paa,

6521: IS
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;

Line 6565: pay_assignment_actions paa,

6561: -- cursor to fetch the prepayment asg_action id for the given payroll asg_action id
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')

Line 6575: select 'Y' from pay_assignment_actions paa,

6571: and paa.payroll_action_id = ppa.payroll_action_id;
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

Line 6598: FROM pay_assignment_actions paa,

6594: --Below cursor fetches the latest payroll run details of the current assignment
6595: CURSOR csr_aggr_asgs_processed(p_person_id NUMBER, p_pre_pay_id NUMBER, p_start_year DATE, p_end_year DATE)
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

Line 6602: pay_assignment_actions paa1, --Prepayments

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
6605: WHERE paa.assignment_id = paaf.assignment_id
6606: AND paaf.person_id = p_person_id

Line 6623: pay_assignment_actions act, --Payroll Run

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,
6627: pay_all_payrolls_f papf ,

Line 6624: pay_assignment_actions act1, --Prepayments

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,
6627: pay_all_payrolls_f papf ,
6628: hr_soft_coding_keyflex flex

Line 6649: FROM pay_assignment_actions

6645:
6646: CURSOR csr_asg_id(c_aggr_max_act_id number)
6647: IS
6648: SELECT assignment_id
6649: FROM pay_assignment_actions
6650: WHERE assignment_action_id = c_aggr_max_act_id;
6651:
6652: -- Declarations for First FPS
6653: l_last_asg_action_id number;

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

6884: end if;
6885: end if; --if (l_flag = 'Y') then
6886:
6887: if l_flag = 'Y' and l_first_fps_prepay_asg = 'N' Then
6888: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
6889: -- Insert assignment into pay_assignment_actions
6890: hr_nonrun_asact.insact ( lockingactid, asg_record.assignment_id, pactid, chunk, NULL );
6891: End if;
6892:

Line 6889: -- Insert assignment into pay_assignment_actions

6885: end if; --if (l_flag = 'Y') then
6886:
6887: if l_flag = 'Y' and l_first_fps_prepay_asg = 'N' Then
6888: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
6889: -- Insert assignment into pay_assignment_actions
6890: hr_nonrun_asact.insact ( lockingactid, asg_record.assignment_id, pactid, chunk, NULL );
6891: End if;
6892:
6893: END LOOP;

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

6977:
6978: if ((asg_rec.asg_act_id = l_aggr_min_act_id) and (l_earlier_processed = 0)) then
6979: hr_utility.set_location('Creating Assignment Action for assignment_id '||asg_rec.assignment_id, 50);
6980:
6981: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
6982: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
6983: -- get the assigment action id of the prepayment payroll action id for the current assignment.
6984: OPEN csr_prepay_asg_act_details(asg_rec.assignment_id, l_pre_pact_id);
6985: FETCH csr_prepay_asg_act_details

Line 6998: /* SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;

6994: hr_utility.set_location('Creating other Assignment Action ids for assignment_id '||asg_rec.assignment_id, 50);
6995:
6996: /*for c_asg in csr_get_other_asg(asg_rec.assignment_id)
6997: loop*/
6998: /* SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
6999: hr_utility.set_location('Creating action for asg '||c_asg.asg_id, 50);
7000: hr_nonrun_asact.insact(lockingactid, c_asg.asg_id, pactid, chunk, NULL );
7001: hr_utility.set_location('Created action for asg '||c_asg.asg_id, 50);*/
7002:

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

7010: FETCH csr_agg_all_asg_act_creat
7011: INTO l_asg_id;
7012:
7013: EXIT WHEN csr_agg_all_asg_act_creat%NOTFOUND;
7014: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7015: hr_utility.set_location('Creating action for asg '||l_asg_id, 50);
7016: hr_nonrun_asact.insact(lockingactid, l_asg_id, pactid, chunk, NULL );
7017: hr_utility.set_location('Created action for asg '||l_asg_id, 50);
7018:

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

7055:
7056: ELSIF l_flag1 = 'Y' THEN
7057: -- Create one assignment action for every assignment
7058: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
7059: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7060:
7061: -- Insert assignment into pay_assignment_actions
7062: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
7063: -- get the assigment action id of the prepayment payroll action id for the current assignment.

Line 7061: -- Insert assignment into pay_assignment_actions

7057: -- Create one assignment action for every assignment
7058: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
7059: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7060:
7061: -- Insert assignment into pay_assignment_actions
7062: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
7063: -- get the assigment action id of the prepayment payroll action id for the current assignment.
7064: OPEN csr_prepay_asg_act_details(asg_rec.assignment_id, l_pre_pact_id);
7065: FETCH csr_prepay_asg_act_details

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

7102: hr_utility.set_location('l_ni_aggr_max_act_id:'|| l_ni_aggr_max_act_id , 50);
7103: hr_utility.set_location('asg_rec.asg_act_id:'|| asg_rec.asg_act_id , 50);
7104: if nvl(l_rti_ni_proc_flag,'N') <> 'Y' and asg_rec.asg_act_id = l_ni_aggr_max_act_id then
7105: hr_utility.set_location('Creating action for rti rpt asg:'|| l_ni_rpt_asg_id, 50);
7106: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7107: -- Insert assignment into pay_assignment_actions
7108: hr_nonrun_asact.insact ( lockingactid, l_ni_rpt_asg_id, pactid, chunk, NULL );
7109: /* -- get the assigment action id of the prepayment payroll action id for the current assignment.
7110: OPEN csr_ni_prepay_asg_act_details(asg_rec.asg_act_id);

Line 7107: -- Insert assignment into pay_assignment_actions

7103: hr_utility.set_location('asg_rec.asg_act_id:'|| asg_rec.asg_act_id , 50);
7104: if nvl(l_rti_ni_proc_flag,'N') <> 'Y' and asg_rec.asg_act_id = l_ni_aggr_max_act_id then
7105: hr_utility.set_location('Creating action for rti rpt asg:'|| l_ni_rpt_asg_id, 50);
7106: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7107: -- Insert assignment into pay_assignment_actions
7108: hr_nonrun_asact.insact ( lockingactid, l_ni_rpt_asg_id, pactid, chunk, NULL );
7109: /* -- get the assigment action id of the prepayment payroll action id for the current assignment.
7110: OPEN csr_ni_prepay_asg_act_details(asg_rec.asg_act_id);
7111: FETCH csr_ni_prepay_asg_act_details

Line 7170: FROM pay_assignment_actions paa,

7166: IS
7167: SELECT aei.assignment_extra_info_id,
7168: aei.object_version_number,
7169: aei.aei_information8
7170: FROM pay_assignment_actions paa,
7171: per_assignment_extra_info aei
7172: WHERE paa.assignment_action_id = p_assact
7173: AND aei.assignment_id = paa.assignment_id
7174: AND aei.information_type = p_type;

Line 7181: FROM pay_assignment_actions paa,

7177: IS
7178: SELECT aei.assignment_extra_info_id,
7179: aei.object_version_number,
7180: aei.aei_information9
7181: FROM pay_assignment_actions paa,
7182: per_assignment_extra_info aei
7183: WHERE paa.assignment_action_id = p_assact
7184: AND aei.assignment_id = paa.assignment_id
7185: AND aei.information_type = p_type;

Line 7192: FROM pay_assignment_actions paa,

7188: IS
7189: SELECT aei.assignment_extra_info_id,
7190: aei.object_version_number,
7191: aei.aei_information19
7192: FROM pay_assignment_actions paa,
7193: per_assignment_extra_info aei
7194: WHERE paa.assignment_action_id = p_assact
7195: AND aei.assignment_id = paa.assignment_id
7196: AND aei.information_type = p_type;

Line 7952: FROM pay_assignment_actions paa

7948: to_number (substr (max (lpad (paa.action_sequence ,15,'0')
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

Line 7971: FROM pay_assignment_actions paa

7967: to_number (substr (max (lpad (paa.action_sequence ,15,'0')
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

Line 8137: pay_assignment_actions paa,

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

Line 8149: pay_assignment_actions paa1,

8145: cursor get_min_asg_actid(p_person_id IN Number,p_assactid IN number)
8146: is
8147: select min(paa2.assignment_action_id) asgactid
8148: from
8149: pay_assignment_actions paa1,
8150: pay_assignment_actions paa2,
8151: per_all_assignments_f asg
8152: where
8153: paa1.assignment_action_id = p_assactid

Line 8150: pay_assignment_actions paa2,

8146: is
8147: select min(paa2.assignment_action_id) asgactid
8148: from
8149: pay_assignment_actions paa1,
8150: pay_assignment_actions paa2,
8151: per_all_assignments_f asg
8152: where
8153: paa1.assignment_action_id = p_assactid
8154: and paa1.payroll_action_id = paa2.payroll_action_id

Line 8166: pay_assignment_actions paa,

8162: asg.EFFECTIVE_START_DATE asg_eff_start_date,
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

Line 8184: pay_assignment_actions paa

8180: trim(NVL(pap.per_information10,'N')) per_paye_agg_flag,
8181: asg.payroll_id payroll_id
8182: FROM per_all_people_f pap,
8183: per_all_assignments_f asg,
8184: pay_assignment_actions paa
8185: WHERE paa.assignment_action_id = c_asg_act_id
8186: AND paa.assignment_id = asg.assignment_id
8187: AND pap.person_id = asg.person_id
8188: -- and asg.business_group_id = l_business_group_id

Line 8202: FROM pay_assignment_actions paa,

8198: /*+ USE_NL(paa, pact, ptp) */
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

Line 8205: pay_assignment_actions paa1, --Prepayments

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
8208: WHERE paa.assignment_id = p_asgid
8209: AND paa.payroll_action_id = pact.payroll_action_id

Line 8228: FROM pay_assignment_actions paa,

8224: /*+ USE_NL(paa, pact, ptp) */
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

Line 8231: pay_assignment_actions paa1, --Prepayments

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
8234: WHERE paa.assignment_id = p_asgid --46959
8235: AND paa.payroll_action_id = pact.payroll_action_id

Line 8254: FROM pay_assignment_actions paa,

8250: IS
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;

Line 8263: FROM pay_assignment_actions paa

8259: ---
8260: CURSOR csr_pay_act_details(p_asg_actid NUMBER)
8261: IS
8262: SELECT paa.payroll_action_id
8263: FROM pay_assignment_actions paa
8264: WHERE paa.assignment_action_id = p_asg_actid;
8265:
8266: --Below cursor verifies whether current payment for this assignment is already archived
8267: CURSOR csr_earlier_archived(p_last_asg_action_id NUMBER)

Line 8333: PAY_ASSIGNMENT_ACTIONS PAA,

8329: pay_org_payment_methods_f popf,
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

Line 8354: pay_assignment_actions paa,

8350: IS
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

Line 8376: FROM pay_assignment_actions paa,

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

Line 8380: pay_assignment_actions paa1, --Prepayments

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
8383: WHERE paa.assignment_id = paaf.assignment_id
8384: AND paaf.person_id = p_person_id

Line 8417: FROM pay_assignment_actions paa

8413: SELECT /*+ USE_NL(paa, pact, ptp) */
8414: to_number (substr (max (lpad (paa.action_sequence ,15,'0')
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

Line 8455: FROM pay_assignment_actions

8451:
8452: CURSOR csr_aggr_sequence_id(c_asg_act_id NUMBER)
8453: IS
8454: SELECT action_sequence
8455: FROM pay_assignment_actions
8456: WHERE assignment_action_id = c_asg_act_id;
8457:
8458: CURSOR csr_aggr_locking_asg_act_id(p_person_id NUMBER, p_action_sequence NUMBER)
8459: IS

Line 8469: ,pay_assignment_actions act

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
8473: AND ass.period_of_service_id = pos.period_of_service_id

Line 8486: pay_assignment_actions paa,

8482: CURSOR csr_processed_in_prepayment(c_prepay_asgactid NUMBER, c_payroll_asgactid NUMBER, c_payroll_master_asgactid number)
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')

Line 8505: from pay_assignment_actions

8501: */
8502:
8503: cursor csr_get_asg_id(c_asgactid number) is
8504: select distinct assignment_id
8505: from pay_assignment_actions
8506: where assignment_action_id = c_asgactid;
8507: -- Curosr to fetch the RTI Reporting flag and effective date of the assignment
8508: cursor csr_ni_rpt_flag(c_asg_id number) is
8509: select AEI_INFORMATION1, AEI_INFORMATION2 from per_assignment_extra_info where assignment_id = c_asg_id

Line 8577: pay_assignment_actions paa,

8573: ***/
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

Line 8593: FROM pay_assignment_actions paa_pre

8589: -- First FPS Cursors
8590: -- cursor to check whether this assignment processed in prepayment or not
8591: cursor csr_prepayment_made(pre_pay_id number) is
8592: SELECT paa_pre.assignment_id
8593: FROM pay_assignment_actions paa_pre
8594: , pay_assignment_actions paa_arcv
8595: WHERE paa_arcv.assignment_action_id = p_assactid
8596: AND paa_pre.payroll_action_id = pre_pay_id
8597: AND paa_pre.assignment_id = paa_arcv.assignment_id;

Line 8594: , pay_assignment_actions paa_arcv

8590: -- cursor to check whether this assignment processed in prepayment or not
8591: cursor csr_prepayment_made(pre_pay_id number) is
8592: SELECT paa_pre.assignment_id
8593: FROM pay_assignment_actions paa_pre
8594: , pay_assignment_actions paa_arcv
8595: WHERE paa_arcv.assignment_action_id = p_assactid
8596: AND paa_pre.payroll_action_id = pre_pay_id
8597: AND paa_pre.assignment_id = paa_arcv.assignment_id;
8598:

Line 8602: FROM pay_assignment_actions paa

8598:
8599: -- cursor to get assignment id using assignment action id parameter
8600: CURSOR csr_asg_id(c_asg_act_id NUMBER) IS
8601: SELECT paa.assignment_id
8602: FROM pay_assignment_actions paa
8603: WHERE paa.assignment_action_id = c_asg_act_id;
8604:
8605: -- To fetch First FPS parameter
8606: /*CURSOR csr_parameter_info IS

Line 8610: , pay_assignment_actions paa

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: */
8614: -- get the defined balance id for specified balance and dimension

Line 8637: FROM pay_assignment_actions paa

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

Line 8660: FROM pay_assignment_actions paa

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

Line 8699: select count(*) from pay_assignment_actions paa, --run

8695: and ASSIGNMENT_ID = c_asg_id
8696: and PAYROLL_ASG_ACT_ID = c_cur_asg_action_id;
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

Line 8700: pay_assignment_actions paa1, --Prepayments

8696: and PAYROLL_ASG_ACT_ID = c_cur_asg_action_id;
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

Line 8719: pay_assignment_actions act, --Payroll Run

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

Line 8720: pay_assignment_actions act1, --Prepayments

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

Line 8746: pay_assignment_actions act, --Payroll Run

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

Line 8747: pay_assignment_actions act1, --Prepayments

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

Line 8772: pay_assignment_actions act, --Payroll Run

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
8776: WHERE

Line 8773: pay_assignment_actions act1, --Prepayments

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
8776: WHERE
8777: ppa.payroll_action_id = g_payroll_action_id

Line 8798: FROM pay_assignment_actions

8794:
8795: CURSOR csr_aggr_master_id(c_child_asg_act_id NUMBER)
8796: IS
8797: SELECT assignment_action_id
8798: FROM pay_assignment_actions
8799: WHERE source_action_id = c_child_asg_act_id;
8800:
8801: CURSOR csr_aggr_max_act_id( p_person_id NUMBER,
8802: p_pre_pact_id NUMBER,

Line 8811: pay_assignment_actions act, --Payroll Run

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

Line 8812: pay_assignment_actions act1, --Prepayments

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

Line 8984: pay_assignment_actions paa

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
8988: and paa.assignment_action_id = pai.locking_action_id;

Line 8994: pay_assignment_actions paa

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
8998: and fcr.CONCURRENT_PROGRAM_ID = fcp.CONCURRENT_PROGRAM_ID

Line 9004: pay_assignment_actions

9000:
9001: -- Modified retry cursor
9002: cursor csr_is_retry_request is
9003: select 'Y' from
9004: pay_assignment_actions
9005: where assignment_action_id = p_assactid
9006: AND ACTION_STATUS = 'M';
9007:
9008: /* To get the payroll action id given assignment action id

Line 9014: pay_assignment_actions paa

9010: cursor csr_prepay_payrol_act(c_asg_act_id number)
9011: is
9012: select paa.payroll_action_id
9013: from
9014: pay_assignment_actions paa
9015: where paa.assignment_action_id = c_asg_act_id;
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

Line 9019: select 'Y' from pay_assignment_actions paa,

9015: where paa.assignment_action_id = c_asg_act_id;
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

Line 9036: FROM pay_assignment_actions paa

9032: to_number (substr (max (lpad (paa.action_sequence ,15,'0')
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

Line 9050: from pay_assignment_actions

9046: AND ptp.regular_payment_date <= g_effective_date;
9047:
9048: CURSOR csr_last_aggr_asg(c_last_asgact_id number) is
9049: select distinct assignment_id
9050: from pay_assignment_actions
9051: where assignment_action_id = c_last_asgact_id;
9052:
9053: --Below cursor fetches the number of assignments processed in current prepayment request
9054: CURSOR csr_aggr_asgs_processed(p_person_id NUMBER, p_pre_pay_id NUMBER, p_start_year DATE, p_end_year DATE)

Line 9057: FROM pay_assignment_actions paa,

9053: --Below cursor fetches the number of assignments processed in current prepayment request
9054: CURSOR csr_aggr_asgs_processed(p_person_id NUMBER, p_pre_pay_id NUMBER, p_start_year DATE, p_end_year DATE)
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

Line 9061: pay_assignment_actions paa1, --Prepayments

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
9064: WHERE paa.assignment_id = paaf.assignment_id
9065: AND paaf.person_id = p_person_id

Line 9082: pay_assignment_actions paa

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:
9086: -- To get maximum assignment action id for the person

Line 9095: pay_assignment_actions paa

9091: || paa.assignment_action_id), 16))
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

Line 9121: pay_assignment_actions paa

9117: CURSOR csr_asg_num(c_asg_act_id NUMBER, c_cur_last_effective_date date)
9118: IS
9119: SELECT asg.assignment_number
9120: FROM per_all_assignments_f asg,
9121: pay_assignment_actions paa
9122: WHERE paa.assignment_action_id = c_asg_act_id
9123: AND paa.assignment_id = asg.assignment_id
9124: AND c_cur_last_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
9125:

Line 9139: from pay_assignment_actions paa,

9135: AND information_type = 'GB_RTI_ASG_DETAILS';
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

Line 9149: from pay_assignment_actions paa

9145: and ppa.report_type in ( 'RTI_FPS_REP' , 'RTI_FPS_REP_13');
9146:
9147: cursor csr_fps_action_exists(c_cur_asg_id number, c_payroll_action_id number) is
9148: select 'Y'
9149: from pay_assignment_actions paa
9150: where paa.payroll_action_id = c_payroll_action_id
9151: and paa.assignment_id = c_cur_asg_id;
9152:
9153: l_aggr_asgs_processed number;

Line 9258: from pay_assignment_actions where assignment_action_id = p_assactid;

9254: --delete from pay_gb_fps_details in case of retry
9255: if l_retry_req_flag = 'Y' then
9256: hr_utility.trace('RETRY : l_retry_req_flag: '|| l_retry_req_flag);
9257: select payroll_action_id into l_pact_id
9258: from pay_assignment_actions where assignment_action_id = p_assactid;
9259: open get_min_asg_actid(l_person_id,p_assactid);
9260: fetch get_min_asg_actid into min_asgactid;
9261: close get_min_asg_actid;
9262:

Line 10193: pay_assignment_actions paa,

10189:
10190: -- should skip the aggregation logic for other assignments
10191: select max(paa.assignment_action_id) into l_asg_action_id
10192: from
10193: pay_assignment_actions paa,
10194: per_all_assignments_f paaf
10195: where
10196: paaf.person_id = l_person_id
10197: and paaf.assignment_id = paa.assignment_id

Line 10314: pay_assignment_actions paa

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
10318: and ppa.payroll_action_id = paa.payroll_action_id

Line 10443: select paa.assignment_action_id into l_assact_id from pay_assignment_actions paa

10439: if (l_fps_action_exists = 'Y') then
10440: --Fix for the bug 16409794 ends here
10441:
10442: -- get the assignment action id for the current assginment id.
10443: select paa.assignment_action_id into l_assact_id from pay_assignment_actions paa
10444: where paa.payroll_action_id = g_payroll_action_id
10445: and paa.assignment_id = l_cur_asg_id;
10446:
10447: if (nvl(l_processed_in_prepayment, 'N') <> 'Y') then

Line 12086: select paa.assignment_action_id into l_ni_rpt_assact_id from pay_assignment_actions paa

12082: /*open csr_get_latest_asg_action(l_ni_rpt_asg_id);
12083: fetch csr_get_latest_asg_action into l_ni_max_asg_act_id, l_ni_max_asg_act_date;
12084: close csr_get_latest_asg_action;
12085: */
12086: select paa.assignment_action_id into l_ni_rpt_assact_id from pay_assignment_actions paa
12087: where paa.payroll_action_id = g_payroll_action_id
12088: and paa.assignment_id = l_ni_rpt_asg_id;
12089: hr_utility.set_location('Calling get_ni_only_asg_details:',1000);
12090: get_ni_only_asg_details(l_ni_rpt_asg_id,

Line 12234: select paa.assignment_action_id into l_ni_rpt_assact_id from pay_assignment_actions paa

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:
12234: select paa.assignment_action_id into l_ni_rpt_assact_id from pay_assignment_actions paa
12235: where paa.payroll_action_id = g_payroll_action_id
12236: and paa.assignment_id = l_ni_rpt_asg_id;
12237: hr_utility.set_location('l_ni_rpt_assact_id: ' || l_ni_rpt_assact_id ,1000);
12238: -- insert_archive_row(p_assactid, p_effective_date,l_archive_tab);

Line 12469: pay_assignment_actions paa

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

Line 12637: pay_assignment_actions paa

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

Line 12648: pay_assignment_actions paa

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

Line 12843: pay_assignment_actions paa,

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