APPS.PAY_PAYUSTIM_XMLP_PKG dependencies on PQP_USTIAA_PKG

Line 54: p_consolidation_set_id := pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',l_param);

50: where organization_id = to_number(PPA_FINDER)
51: and attribute1 = 'TIAA-CREF'
52: and rownum=1;
53:
54: p_consolidation_set_id := pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',l_param);
55: p_payroll_id := pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',l_param);
56: p_gre_id := pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',l_param);
57:
58: pqp_tiaalod_pkg.Chk_Neg_Amt(p_payroll_action_id => PACTID);

Line 55: p_payroll_id := pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',l_param);

51: and attribute1 = 'TIAA-CREF'
52: and rownum=1;
53:
54: p_consolidation_set_id := pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',l_param);
55: p_payroll_id := pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',l_param);
56: p_gre_id := pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',l_param);
57:
58: pqp_tiaalod_pkg.Chk_Neg_Amt(p_payroll_action_id => PACTID);
59:

Line 56: p_gre_id := pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',l_param);

52: and rownum=1;
53:
54: p_consolidation_set_id := pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',l_param);
55: p_payroll_id := pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',l_param);
56: p_gre_id := pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',l_param);
57:
58: pqp_tiaalod_pkg.Chk_Neg_Amt(p_payroll_action_id => PACTID);
59:
60: exception when others then