APPS.PQP_US_STUDENT_BEE dependencies on PAY_ELEMENT_TYPES_F

Line 91: From pay_element_types_f pet

87: )
88: and pee.element_link_id = pel.element_link_id
89: and pel.element_type_id in
90: (Select pet.element_type_id
91: From pay_element_types_f pet
92: Where pet.element_information_category = 'US_EARNINGS'
93: and pet.business_group_id = c_bg_id
94: and pet.element_information1 ='SE'
95: and c_end_date between pet.effective_start_date

Line 471: from pay_element_types_f

467: -- ===========================================================================
468: cursor get_element_name (p_element_type_id number,
469: p_effective_date date) is
470: select element_name
471: from pay_element_types_f
472: where element_type_id = p_element_type_id
473: and p_effective_date between effective_start_date
474: and effective_end_date;
475: -- Type declarations

Line 509: l_element_name pay_element_types_f.element_name%type;

505:
506: -- Type casted variables
507: l_assignment_id per_assignments_f.assignment_id%type;
508: l_assignment_number per_assignments_f.assignment_number%type;
509: l_element_name pay_element_types_f.element_name%type;
510: l_person_id per_people_f.person_id%type;
511: l_ssn per_people_f.national_identifier%type;
512: l_party_id per_people_f.party_id%type;
513: l_proc_name constant varchar2(150) :=