APPS.JTF_TTY_WEBADI_SALSTEAM_UPDATE dependencies on JTF_TTY_ALIGNMENTS

Line 680: jtf_tty_alignments al

676:
677: CURSOR c_get_user_id (l_align_id number )
678: IS SELECT rsc.user_id
679: FROM jtf_rs_resource_extns rsc,
680: jtf_tty_alignments al
681: WHERE rsc.resource_id = al.owner_resource_id
682: AND al.owner_resource_type = 'RS_EMPLOYEE'
683: AND al.alignment_id = l_align_id;
684:

Line 798: FROM JTF_TTY_ALIGNMENTS

794:
795: BEGIN
796: IF P_ALIGNMENT_ID IS NOT NULL THEN
797: SELECT 'VALID' INTO l_found
798: FROM JTF_TTY_ALIGNMENTS
799: WHERE alignment_id = P_ALIGNMENT_ID
800: AND l_user_id = created_by;
801: END IF;
802:

Line 2169: from jtf_tty_alignments

2165: /* Check to see if this is the first time alignment is being uploaded */
2166: begin
2167: select imported_on
2168: into l_imported_on
2169: from jtf_tty_alignments
2170: where alignment_id = p_alignment_id;
2171: exception
2172: when no_data_found then null;
2173: end;