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(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: ORDER BY phaev.element_reporting_name';

Line 425: FROM pay_action_interlocks

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

Line 551: FROM pay_action_interlocks ai

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

Line 591: FROM pay_action_interlocks

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

Line 689: FROM pay_action_interlocks

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

Line 814: FROM pay_action_interlocks

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

Line 918: FROM pay_action_interlocks

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