[Home] [Help]
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
1541: AND pact.action_type IN ('Q','R','B','I','V')
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
1609: and paa_fps.assignment_action_id = pai.locking_action_id
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
2349: AND pact.action_type IN ('Q','R','B','I','V')
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
2417: and paa_fps.assignment_action_id = pai.locking_action_id
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
2465: AND paa.payroll_action_id = pact.payroll_action_id
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
3163: AND pact.action_type IN ('Q','R','B','I','V')
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
3231: and paa_fps.assignment_action_id = pai.locking_action_id
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
6206: AND appa.action_type IN ('R','Q','V','B') -- Payroll Run or Quickpay Run
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
6336: AND act.payroll_action_id = appa.payroll_action_id
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
6372: AND act.payroll_action_id = appa.payroll_action_id
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
6415: AND paaf.person_id = p_person_id
6416: AND paa.payroll_action_id = pact.payroll_action_id
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
6473: AND paaf.person_id = p_person_id
6474: AND paa.payroll_action_id = pact.payroll_action_id
6508:
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')
6560:
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
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
6608: AND pact.time_period_id = ptp.time_period_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
6629: WHERE as1.person_id = p_person_id --58105
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
8211: AND pact.action_type IN ('Q','R','I','V','B')
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
8237: AND pact.action_type IN ('Q','R','I','V','B')
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
8386: AND pact.time_period_id = ptp.time_period_id
8481: -- CURSOR csr_processed_in_prepayment(c_prepay_asgactid NUMBER, c_payroll_asgactid NUMBER)
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
8493: OR pai.locked_action_id = c_payroll_master_asgactid );
8494:
8495: /*
8496: SELECT 'Y' this_prepayment
8497: FROM pay_action_interlocks pai
8498: WHERE locking_action_id = c_prepay_asgactid
8499: AND (locked_action_id = c_payroll_asgactid
8500: OR locked_action_id = c_payroll_master_asgactid );
8501: */
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
8706: AND paa1.payroll_action_id = ppa1.payroll_action_id
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
8725: AND act.payroll_action_id = appa.payroll_action_id
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
8752: AND act.payroll_action_id = appa.payroll_action_id
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
8778: AND as1.person_id = c_person_id --BETWEEN stperson AND endperson
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
8817: AND act.payroll_action_id = appa.payroll_action_id
8978:
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')
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
9067: AND pact.time_period_id = ptp.time_period_id
10308:
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