APPS.PQP_GB_OMP_EARNINGS dependencies on PER_ASSIGNMENTS_F

Line 5: l_person_id per_assignments_f.person_id%TYPE;

1: PACKAGE BODY pqp_gb_omp_earnings AS
2: /* $Header: pqpgboae.pkb 115.1 2002/12/03 11:31:20 cchappid noship $ */
3:
4: g_proc_name VARCHAR2(80) := 'pqp_gb_omp_earnings.';
5: l_person_id per_assignments_f.person_id%TYPE;
6:
7: /*========================================================================
8: * CALCULATE_SMP_AVERAGE_EARNINGS
9: * This Function Returns the Average Earnings (SMP Earnings)Value of

Line 32: FROM per_assignments_f

28: AND effective_date = p_effective_date ;
29:
30: CURSOR csr_person_id ( p_assignment_id IN NUMBER ) IS
31: SELECT person_id
32: FROM per_assignments_f
33: WHERE assignment_id = p_assignment_id ;
34:
35: l_smp_average_earnings NUMBER := 0;
36: l_user_entered VARCHAR2(1) := 'N' ;