[Home] [Help]
2378: cursor plbc is
2379: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2380: USE_NL (PLB) */
2381: plb.latest_balance_id
2382: from pay_defined_balances pdb,
2383: pay_person_latest_balances plb
2384: where pdb.balance_type_id = l_balance_type_id
2385: and plb.defined_balance_id = pdb.defined_balance_id
2386: and exists (
2394: --
2395: cursor lbc is
2396: select
2397: lb.latest_balance_id
2398: from pay_defined_balances pdb,
2399: pay_latest_balances lb
2400: where pdb.balance_type_id = l_balance_type_id
2401: and lb.defined_balance_id = pdb.defined_balance_id
2402: and exists (
2412: cursor albc is
2413: select /*+ ORDERED INDEX (PLB PAY_ASSIGNMENT_LATEST_BALA_FK2)
2414: USE_NL (PLB) */
2415: plb.latest_balance_id
2416: from pay_defined_balances pdb,
2417: pay_assignment_latest_balances plb
2418: where pdb.balance_type_id = l_balance_type_id
2419: and plb.defined_balance_id = pdb.defined_balance_id
2420: and exists (
2429: cursor platbalc is
2430: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2431: USE_NL (PLB) */
2432: plb.latest_balance_id
2433: from pay_defined_balances pdb,
2434: pay_person_latest_balances plb
2435: where pdb.balance_type_id = l_balance_type_id
2436: and plb.defined_balance_id = pdb.defined_balance_id;
2437: --
2439: cursor alatbalc is
2440: select /*+ ORDERED INDEX (PLB PAY_ASSIGNMENT_LATEST_BALA_FK2)
2441: USE_NL (PLB) */
2442: plb.latest_balance_id
2443: from pay_defined_balances pdb,
2444: pay_assignment_latest_balances plb
2445: where pdb.balance_type_id = l_balance_type_id
2446: and plb.defined_balance_id = pdb.defined_balance_id;
2447: --
2449: cursor latbalc is
2450: select /*+ ORDERED INDEX (PLB PAY_LATEST_BALANCES_FK1)
2451: USE_NL (PLB) */
2452: plb.latest_balance_id
2453: from pay_defined_balances pdb,
2454: pay_latest_balances plb
2455: where pdb.balance_type_id = l_balance_type_id
2456: and plb.defined_balance_id = pdb.defined_balance_id;
2457: --
2469: -- Select the balances that are PL/SQL fed.
2470: cursor pl_feed_chk_a is
2471: select alb.latest_balance_id
2472: from pay_assignment_latest_balances alb,
2473: pay_defined_balances pdb,
2474: pay_balance_dimensions pbd
2475: where pdb.balance_type_id = l_balance_type_id
2476: and pdb.defined_balance_id = alb.defined_balance_id
2477: and pdb.balance_dimension_id = pbd.balance_dimension_id
2480: cursor pl_feed_chk is
2481: select plb.latest_balance_id,
2482: 'P' balance_type
2483: from pay_person_latest_balances plb,
2484: pay_defined_balances pdb,
2485: pay_balance_dimensions pbd
2486: where pdb.balance_type_id = l_balance_type_id
2487: and pdb.defined_balance_id = plb.defined_balance_id
2488: and pdb.balance_dimension_id = pbd.balance_dimension_id
2490: union
2491: select plb.latest_balance_id,
2492: 'B' balance_type
2493: from pay_latest_balances plb,
2494: pay_defined_balances pdb,
2495: pay_balance_dimensions pbd
2496: where pdb.balance_type_id = l_balance_type_id
2497: and pdb.defined_balance_id = plb.defined_balance_id
2498: and pdb.balance_dimension_id = pbd.balance_dimension_id
2822: cursor plbc is
2823: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2824: USE_NL (PLB) */
2825: plb.latest_balance_id
2826: from pay_defined_balances pdb,
2827: pay_person_latest_balances plb
2828: where pdb.balance_type_id = l_balance_type_id
2829: and plb.defined_balance_id = pdb.defined_balance_id;
2830: --
2832: cursor albc is
2833: select /*+ ORDERED INDEX (PLB PAY_ASSIGNMENT_LATEST_BALA_FK2)
2834: USE_NL (PLB) */
2835: plb.latest_balance_id
2836: from pay_defined_balances pdb,
2837: pay_assignment_latest_balances plb
2838: where pdb.balance_type_id = l_balance_type_id
2839: and plb.defined_balance_id = pdb.defined_balance_id;
2840: -- Select all latest balances to delete.
2841: cursor lbc is
2842: select /*+ ORDERED INDEX (LB PAY_LATEST_BALANCES_FK1)
2843: USE_NL (LB) */
2844: lb.latest_balance_id
2845: from pay_defined_balances pdb,
2846: pay_latest_balances lb
2847: where pdb.balance_type_id = l_balance_type_id
2848: and lb.defined_balance_id = pdb.defined_balance_id;
2849:
2949: plb.latest_balance_id
2950: from
2951: pay_input_values_f piv,
2952: pay_balance_feeds_f pbf,
2953: pay_defined_balances pdb,
2954: pay_person_latest_balances plb,
2955: pay_assignment_actions paa,
2956: pay_payroll_actions ppa
2957: where plb.person_id = p_person_id
2972: alb.latest_balance_id
2973: from pay_assignment_latest_balances alb,
2974: pay_assignment_actions act,
2975: pay_payroll_actions pac,
2976: pay_defined_balances pdb,
2977: pay_balance_feeds_f pbf,
2978: pay_input_values_f piv
2979: where act.assignment_id = alb.assignment_id
2980: and alb.assignment_id in
2999: plb.latest_balance_id
3000: from
3001: pay_input_values_f piv,
3002: pay_balance_feeds_f pbf,
3003: pay_defined_balances pdb,
3004: pay_latest_balances plb,
3005: pay_assignment_actions paa,
3006: pay_payroll_actions ppa
3007: where plb.person_id = p_person_id
7056: pdb.balance_dimension_id,
7057: pdb.balance_type_id,
7058: pbf.scale
7059: from pay_latest_balances plb,
7060: pay_defined_balances pdb,
7061: pay_balance_feeds_f pbf
7062: where pbf.input_value_id = p_inp_val_id
7063: and effdate between pbf.effective_start_date
7064: and pbf.effective_end_date
7089: pdb.balance_dimension_id,
7090: pdb.balance_type_id,
7091: pbf.scale
7092: from pay_assignment_latest_balances palb,
7093: pay_defined_balances pdb,
7094: pay_balance_feeds_f pbf
7095: where pbf.input_value_id = p_inp_val_id
7096: and effdate between pbf.effective_start_date
7097: and pbf.effective_end_date
7114: pdb.balance_dimension_id,
7115: pdb.balance_type_id,
7116: pbf.scale
7117: from pay_person_latest_balances pplb,
7118: pay_defined_balances pdb,
7119: pay_balance_feeds_f pbf
7120: where pbf.input_value_id = p_inp_val_id
7121: and effdate between pbf.effective_start_date
7122: and pbf.effective_end_date