APPS.PAYPLNK dependencies on PER_ASSIGNMENTS_F

Line 708: from per_assignments_f asg

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

Line 758: from per_assignments_f asg

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

Line 863: from per_assignments_f asg

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

Line 884: from per_assignments_f asg

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

Line 931: from per_assignments_f asg

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

Line 3390: -- from per_assignments_f asg

3386: -- (g_line_record.assignment_number is not null) then
3387: -- begin
3388: -- select asg.assignment_id
3389: -- into l_assignment_id
3390: -- from per_assignments_f asg
3391: -- where asg.assignment_number =
3392: -- g_line_record.assignment_number
3393: -- and g_line_record.effective_date between asg.effective_start_date
3394: -- and asg.effective_end_date

Line 3410: -- from per_assignments_f asg

3406: -- begin
3407: -- if(not_upper = true) then
3408: -- select asg.assignment_id
3409: -- into l_assignment_id
3410: -- from per_assignments_f asg
3411: -- where upper(asg.assignment_number) =
3412: -- (g_line_record.assignment_number)
3413: -- and g_line_record.effective_date between
3414: -- asg.effective_start_date

Line 3452: -- from per_assignments_f asg

3448: -- (g_line_record.assignment_number is not null) then
3449: -- begin
3450: -- select 'x'
3451: -- into l_assignment_exists
3452: -- from per_assignments_f asg
3453: -- where asg.assignment_number =
3454: -- g_line_record.assignment_number
3455: -- and asg.assignment_id = g_line_record.assignment_id
3456: -- and g_line_record.effective_date between asg.effective_start_date

Line 3473: -- from per_assignments_f asg

3469: -- begin
3470: -- if(not_upper = true) then
3471: -- select 'x'
3472: -- into l_assignment_exists
3473: -- from per_assignments_f asg
3474: -- where upper(asg.assignment_number) =
3475: -- upper(g_line_record.assignment_number)
3476: -- and asg.assignment_id = g_line_record.assignment_id
3477: -- and g_line_record.effective_date between asg.effective_start_date

Line 3508: -- from per_assignments_f asg

3504: -- else
3505: -- begin
3506: -- select 'x'
3507: -- into l_assignment_exists
3508: -- from per_assignments_f asg
3509: -- where asg.assignment_id = g_line_record.assignment_id
3510: -- and g_line_record.effective_date between asg.effective_start_date
3511: -- and asg.effective_end_date
3512: -- and asg.business_group_id +0 = p_business_group_id;