APPS.FV_FEDERAL_PAYMENT_FIELDS_PKG dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 35: iby_pay_instructions_all ipia

31:
32: select fed_employer_id_number
33: into l_fed_employer_number
34: from fv_operating_units_all foua,
35: iby_pay_instructions_all ipia
36: where ipia.payment_instruction_id = p_payment_instruction_id
37: and ipia.org_id = foua.org_id;
38:
39: return l_fed_employer_number;

Line 353: l_instruction_name iby_pay_instructions_all.pay_admin_assigned_ref_code%TYPE;

349: l_finalseq Fv_Pb_Seq_Assignments_All.next_seq_value%TYPE;
350: l_prefix Fv_Pb_Seq_Assignments_All.prefix%TYPE;
351: l_suffix Fv_Pb_Seq_Assignments_All.suffix%TYPE;
352: l_seq_assignment_id Fv_Pb_Seq_Assignments_All.seq_assignment_id%TYPE;
353: l_instruction_name iby_pay_instructions_all.pay_admin_assigned_ref_code%TYPE;
354: l_count NUMBER;
355: l_pi_count NUMBER;
356: l_module varchar2(200) := G_PKG_NAME || '.GET_PAY_INSTR_SEQ_NUM';
357: l_message VARCHAR2(1000);

Line 420: FROM iby_pay_instructions_all

416: -- Check for Uniqueness
417: LOOP
418: SELECT COUNT(*)
419: INTO l_pi_count
420: FROM iby_pay_instructions_all
421: WHERE org_id = p_org_id
422: AND pay_admin_assigned_ref_code = l_instruction_name;
423:
424: IF (l_pi_count = 0) THEN