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 659: l_business_group_id per_assignments_f.business_group_id%TYPE;

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

Line 678: from per_assignments_f pa

674: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;
675: --
676: cursor bgsel is
677: select pa.business_group_id
678: from per_assignments_f pa
679: where pa.assignment_id = p_assignment_id
680: and p_effective_date between pa.effective_start_date
681: and pa.effective_end_date;
682: --

Line 2099: l_business_group_id per_assignments_f.business_group_id%TYPE;

2095: -- Declare cursors and local variables
2096: --
2097: --
2098: l_proc varchar2(72);
2099: l_business_group_id per_assignments_f.business_group_id%TYPE;
2100: l_validate boolean := FALSE;
2101: l_external_account_id
2102: pay_personal_payment_methods_f.external_account_id%TYPE;
2103: l_object_version_number