[Home] [Help]
2346: cursor plbc is
2347: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2348: USE_NL (PLB) */
2349: plb.latest_balance_id
2350: from pay_defined_balances pdb,
2351: pay_person_latest_balances plb
2352: where pdb.balance_type_id = l_balance_type_id
2353: and plb.defined_balance_id = pdb.defined_balance_id
2354: and exists (
2362: --
2363: cursor lbc is
2364: select
2365: lb.latest_balance_id
2366: from pay_defined_balances pdb,
2367: pay_latest_balances lb
2368: where pdb.balance_type_id = l_balance_type_id
2369: and lb.defined_balance_id = pdb.defined_balance_id
2370: and exists (
2380: cursor albc is
2381: select /*+ ORDERED INDEX (PLB PAY_ASSIGNMENT_LATEST_BALA_FK2)
2382: USE_NL (PLB) */
2383: plb.latest_balance_id
2384: from pay_defined_balances pdb,
2385: pay_assignment_latest_balances plb
2386: where pdb.balance_type_id = l_balance_type_id
2387: and plb.defined_balance_id = pdb.defined_balance_id
2388: and exists (
2397: cursor platbalc is
2398: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2399: USE_NL (PLB) */
2400: plb.latest_balance_id
2401: from pay_defined_balances pdb,
2402: pay_person_latest_balances plb
2403: where pdb.balance_type_id = l_balance_type_id
2404: and plb.defined_balance_id = pdb.defined_balance_id;
2405: --
2407: cursor alatbalc is
2408: select /*+ ORDERED INDEX (PLB PAY_ASSIGNMENT_LATEST_BALA_FK2)
2409: USE_NL (PLB) */
2410: plb.latest_balance_id
2411: from pay_defined_balances pdb,
2412: pay_assignment_latest_balances plb
2413: where pdb.balance_type_id = l_balance_type_id
2414: and plb.defined_balance_id = pdb.defined_balance_id;
2415: --
2417: cursor latbalc is
2418: select /*+ ORDERED INDEX (PLB PAY_LATEST_BALANCES_FK1)
2419: USE_NL (PLB) */
2420: plb.latest_balance_id
2421: from pay_defined_balances pdb,
2422: pay_latest_balances plb
2423: where pdb.balance_type_id = l_balance_type_id
2424: and plb.defined_balance_id = pdb.defined_balance_id;
2425: --
2437: -- Select the balances that are PL/SQL fed.
2438: cursor pl_feed_chk_a is
2439: select alb.latest_balance_id
2440: from pay_assignment_latest_balances alb,
2441: pay_defined_balances pdb,
2442: pay_balance_dimensions pbd
2443: where pdb.balance_type_id = l_balance_type_id
2444: and pdb.defined_balance_id = alb.defined_balance_id
2445: and pdb.balance_dimension_id = pbd.balance_dimension_id
2448: cursor pl_feed_chk is
2449: select plb.latest_balance_id,
2450: 'P' balance_type
2451: from pay_person_latest_balances plb,
2452: pay_defined_balances pdb,
2453: pay_balance_dimensions pbd
2454: where pdb.balance_type_id = l_balance_type_id
2455: and pdb.defined_balance_id = plb.defined_balance_id
2456: and pdb.balance_dimension_id = pbd.balance_dimension_id
2458: union
2459: select plb.latest_balance_id,
2460: 'B' balance_type
2461: from pay_latest_balances plb,
2462: pay_defined_balances pdb,
2463: pay_balance_dimensions pbd
2464: where pdb.balance_type_id = l_balance_type_id
2465: and pdb.defined_balance_id = plb.defined_balance_id
2466: and pdb.balance_dimension_id = pbd.balance_dimension_id
2805: cursor plbc is
2806: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2807: USE_NL (PLB) */
2808: plb.latest_balance_id
2809: from pay_defined_balances pdb,
2810: pay_person_latest_balances plb
2811: where pdb.balance_type_id = l_balance_type_id
2812: and plb.defined_balance_id = pdb.defined_balance_id;
2813: --
2815: cursor albc is
2816: select /*+ ORDERED INDEX (PLB PAY_ASSIGNMENT_LATEST_BALA_FK2)
2817: USE_NL (PLB) */
2818: plb.latest_balance_id
2819: from pay_defined_balances pdb,
2820: pay_assignment_latest_balances plb
2821: where pdb.balance_type_id = l_balance_type_id
2822: and plb.defined_balance_id = pdb.defined_balance_id;
2823: -- Select all latest balances to delete.
2824: cursor lbc is
2825: select /*+ ORDERED INDEX (LB PAY_LATEST_BALANCES_FK1)
2826: USE_NL (LB) */
2827: lb.latest_balance_id
2828: from pay_defined_balances pdb,
2829: pay_latest_balances lb
2830: where pdb.balance_type_id = l_balance_type_id
2831: and lb.defined_balance_id = pdb.defined_balance_id;
2832:
2932: plb.latest_balance_id
2933: from
2934: pay_input_values_f piv,
2935: pay_balance_feeds_f pbf,
2936: pay_defined_balances pdb,
2937: pay_person_latest_balances plb,
2938: pay_assignment_actions paa,
2939: pay_payroll_actions ppa
2940: where plb.person_id = p_person_id
2955: alb.latest_balance_id
2956: from pay_assignment_latest_balances alb,
2957: pay_assignment_actions act,
2958: pay_payroll_actions pac,
2959: pay_defined_balances pdb,
2960: pay_balance_feeds_f pbf,
2961: pay_input_values_f piv
2962: where act.assignment_id = alb.assignment_id
2963: and alb.assignment_id in
2982: plb.latest_balance_id
2983: from
2984: pay_input_values_f piv,
2985: pay_balance_feeds_f pbf,
2986: pay_defined_balances pdb,
2987: pay_latest_balances plb,
2988: pay_assignment_actions paa,
2989: pay_payroll_actions ppa
2990: where plb.person_id = p_person_id
6792: pdb.balance_dimension_id,
6793: pdb.balance_type_id,
6794: pbf.scale
6795: from pay_latest_balances plb,
6796: pay_defined_balances pdb,
6797: pay_balance_feeds_f pbf
6798: where pbf.input_value_id = p_inp_val_id
6799: and effdate between pbf.effective_start_date
6800: and pbf.effective_end_date
6825: pdb.balance_dimension_id,
6826: pdb.balance_type_id,
6827: pbf.scale
6828: from pay_assignment_latest_balances palb,
6829: pay_defined_balances pdb,
6830: pay_balance_feeds_f pbf
6831: where pbf.input_value_id = p_inp_val_id
6832: and effdate between pbf.effective_start_date
6833: and pbf.effective_end_date
6850: pdb.balance_dimension_id,
6851: pdb.balance_type_id,
6852: pbf.scale
6853: from pay_person_latest_balances pplb,
6854: pay_defined_balances pdb,
6855: pay_balance_feeds_f pbf
6856: where pbf.input_value_id = p_inp_val_id
6857: and effdate between pbf.effective_start_date
6858: and pbf.effective_end_date