APPS.HR_PERSONAL_PAY_METHOD_API dependencies on PER_ASSIGNMENTS_F

Line 57: per_assignments_f asg

53: --
54: cursor legsel is
55: select pbg.legislation_code
56: from per_business_groups pbg,
57: per_assignments_f asg
58: where pbg.business_group_id = asg.business_group_id
59: and asg.assignment_id = p_assignment_id
60: and p_effective_date between asg.effective_start_date
61: and asg.effective_end_date;

Line 655: l_business_group_id per_assignments_f.business_group_id%TYPE;

651: --
652: -- Declare cursors and local variables
653: --
654: l_proc varchar2(72);
655: l_business_group_id per_assignments_f.business_group_id%TYPE;
656: l_external_account_id pay_personal_payment_methods_f.external_account_id%TYPE;
657: l_validate boolean := FALSE;
658: l_exa_ovn number;
659: l_exists varchar2(1);

Line 674: from per_assignments_f pa

670: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;
671: --
672: cursor bgsel is
673: select pa.business_group_id
674: from per_assignments_f pa
675: where pa.assignment_id = p_assignment_id
676: and p_effective_date between pa.effective_start_date
677: and pa.effective_end_date;
678: --

Line 1904: l_business_group_id per_assignments_f.business_group_id%TYPE;

1900: -- Declare cursors and local variables
1901: --
1902: --
1903: l_proc varchar2(72);
1904: l_business_group_id per_assignments_f.business_group_id%TYPE;
1905: l_validate boolean := FALSE;
1906: l_external_account_id
1907: pay_personal_payment_methods_f.external_account_id%TYPE;
1908: l_object_version_number