APPS.PAY_HK_SOE_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 290: FROM pay_action_interlocks

286:
287: CURSOR csr_locked_action_id
288: IS
289: SELECT max(locked_action_id)
290: FROM pay_action_interlocks
291: WHERE locking_action_id = p_assignment_action_id;
292:
293: BEGIN
294:

Line 315: pay_action_interlocks pai

311:
312: g_sql:=' SELECT phaev.element_reporting_name COL02
313: , TO_CHAR(SUM(phaev.amount), fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
314: FROM pay_hk_asg_elements_v phaev,
315: pay_action_interlocks pai
316: WHERE pai.locked_action_id = phaev.assignment_action_id
317: AND pai.locking_action_id = ' || p_assignment_action_id || '
318: AND (phaev.classification_name like ''%''||''' || p_classification_name || ''' ||''%'')
319: GROUP BY phaev.element_reporting_name

Line 426: FROM pay_action_interlocks

422:
423: CURSOR csr_locked_action_id
424: IS
425: SELECT max(locked_action_id)
426: FROM pay_action_interlocks
427: WHERE locking_action_id = p_assignment_action_id;
428:
429: CURSOR csr_get_date_earned
430: IS

Line 552: FROM pay_action_interlocks ai

548: , pay_org_payment_methods_f opm
549: , pay_payment_types_tl pt
550: WHERE pp.assignment_action_id IN
551: (SELECT ai.locking_action_id
552: FROM pay_action_interlocks ai
553: WHERE ai.locked_action_id :action_clause)
554: AND pp.personal_payment_method_id = ppm.personal_payment_method_id(+)
555: AND :effective_date BETWEEN ppm.effective_start_date(+)
556: AND ppm.effective_end_date(+)

Line 592: FROM pay_action_interlocks

588:
589: CURSOR csr_prepayment
590: IS
591: SELECT MAX(locked_action_id)
592: FROM pay_action_interlocks
593: WHERE locking_action_id = p_assignment_action_id;
594:
595: CURSOR csr_get_bg_id
596: IS

Line 690: FROM pay_action_interlocks

686:
687: CURSOR csr_locked_action_id
688: IS
689: SELECT max(locked_action_id)
690: FROM pay_action_interlocks
691: WHERE locking_action_id = p_assignment_action_id;
692:
693: CURSOR csr_get_date_earned
694: IS

Line 815: FROM pay_action_interlocks

811:
812: CURSOR csr_prepayment
813: IS
814: SELECT MAX(locked_action_id)
815: FROM pay_action_interlocks
816: WHERE locking_action_id = p_assignment_action_id;
817:
818: l_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
819: l_accrual_category pay_accrual_plans.accrual_category%TYPE;

Line 917: FROM pay_action_interlocks

913:
914: CURSOR csr_prepayment
915: IS
916: SELECT MAX(locked_action_id)
917: FROM pay_action_interlocks
918: WHERE locking_action_id = p_assignment_action_id;
919:
920: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
921: