APPS.PAYPLNK dependencies on PER_ASSIGNMENTS_F

Line 710: from per_assignments_f asg

706: (g_line_record.assignment_number is not null) then
707: begin
708: select asg.assignment_id
709: into l_assignment_id
710: from per_assignments_f asg
711: where asg.assignment_number =
712: g_line_record.assignment_number
713: and g_line_record.effective_date between asg.effective_start_date
714: and asg.effective_end_date

Line 760: from per_assignments_f asg

756: begin
757: if(not_upper = true) then
758: select asg.assignment_id
759: into l_assignment_id
760: from per_assignments_f asg
761: where upper(asg.assignment_number) =
762: upper(g_line_record.assignment_number)
763: and g_line_record.effective_date between
764: asg.effective_start_date

Line 865: from per_assignments_f asg

861: (g_line_record.assignment_number is not null) then
862: begin
863: select 'x'
864: into l_assignment_exists
865: from per_assignments_f asg
866: where asg.assignment_number =
867: g_line_record.assignment_number
868: and asg.assignment_id = g_line_record.assignment_id
869: and g_line_record.effective_date between asg.effective_start_date

Line 886: from per_assignments_f asg

882: begin
883: if(not_upper = true) then
884: select 'x'
885: into l_assignment_exists
886: from per_assignments_f asg
887: where upper(asg.assignment_number) =
888: upper(g_line_record.assignment_number)
889: and asg.assignment_id = g_line_record.assignment_id
890: and g_line_record.effective_date between asg.effective_start_date

Line 933: from per_assignments_f asg

929: else
930: begin
931: select 'x'
932: into l_assignment_exists
933: from per_assignments_f asg
934: where asg.assignment_id = g_line_record.assignment_id
935: and g_line_record.effective_date between asg.effective_start_date
936: and asg.effective_end_date
937: and asg.business_group_id +0 = p_business_group_id;

Line 3399: -- from per_assignments_f asg

3395: -- (g_line_record.assignment_number is not null) then
3396: -- begin
3397: -- select asg.assignment_id
3398: -- into l_assignment_id
3399: -- from per_assignments_f asg
3400: -- where asg.assignment_number =
3401: -- g_line_record.assignment_number
3402: -- and g_line_record.effective_date between asg.effective_start_date
3403: -- and asg.effective_end_date

Line 3419: -- from per_assignments_f asg

3415: -- begin
3416: -- if(not_upper = true) then
3417: -- select asg.assignment_id
3418: -- into l_assignment_id
3419: -- from per_assignments_f asg
3420: -- where upper(asg.assignment_number) =
3421: -- (g_line_record.assignment_number)
3422: -- and g_line_record.effective_date between
3423: -- asg.effective_start_date

Line 3461: -- from per_assignments_f asg

3457: -- (g_line_record.assignment_number is not null) then
3458: -- begin
3459: -- select 'x'
3460: -- into l_assignment_exists
3461: -- from per_assignments_f asg
3462: -- where asg.assignment_number =
3463: -- g_line_record.assignment_number
3464: -- and asg.assignment_id = g_line_record.assignment_id
3465: -- and g_line_record.effective_date between asg.effective_start_date

Line 3482: -- from per_assignments_f asg

3478: -- begin
3479: -- if(not_upper = true) then
3480: -- select 'x'
3481: -- into l_assignment_exists
3482: -- from per_assignments_f asg
3483: -- where upper(asg.assignment_number) =
3484: -- upper(g_line_record.assignment_number)
3485: -- and asg.assignment_id = g_line_record.assignment_id
3486: -- and g_line_record.effective_date between asg.effective_start_date

Line 3517: -- from per_assignments_f asg

3513: -- else
3514: -- begin
3515: -- select 'x'
3516: -- into l_assignment_exists
3517: -- from per_assignments_f asg
3518: -- where asg.assignment_id = g_line_record.assignment_id
3519: -- and g_line_record.effective_date between asg.effective_start_date
3520: -- and asg.effective_end_date
3521: -- and asg.business_group_id +0 = p_business_group_id;