APPS.PAY_ELEMENT_EXTRACT_PKG dependencies on PER_ASSIGNMENTS_F

Line 98: from Varchar2(10) to per_assignments_f.employment_category%type.

94: 20-JUL-2004 ahanda 115.19 3778025 Changes query lv_element_result_query
95: to use bind parameters. Also, removed
96: special login for Invol Calculator element.
97: 10-SEP-2004 schauhan 115.20 3650988 Changed the size of the variable lv_employment_category_code
98: from Varchar2(10) to per_assignments_f.employment_category%type.
99: 10-MAR-2005 rajeesha 115.21 4214739 Used Status Column in ltr_elements in Extract_element
100: to avoid the entries which are Replace
101: 24-APR-2006 ppanda 115.23 5167072 Element Register Report was not picking up
102: any data for Secondary classification.

Line 694: per_assignments_f paf,

690: ,paf.assignment_number
691: ,paf.employment_category
692: from pay_payroll_actions ppa,
693: pay_assignment_actions paa,
694: per_assignments_f paf,
695: per_people_f ppf,
696: pay_payrolls_f pf,
697: fnd_common_lookups fcl
698: where ppa.action_type in ('R', 'Q', 'B', 'I', 'V')

Line 1019: lv_employment_category_code per_assignments_f.employment_category%type; --Bug 3650988

1015: lv_org_name VARCHAR2(240);
1016: lv_payroll_name VARCHAR2(100);
1017: lv_location_code VARCHAR2(60);
1018: lv_assignment_status VARCHAR2(100);
1019: lv_employment_category_code per_assignments_f.employment_category%type; --Bug 3650988
1020: lv_employment_category VARCHAR2(100);
1021:
1022: lv_element_name VARCHAR2(100);
1023: lv_element_value VARCHAR2(100);

Line 1260: per_assignments_f paf

1256: per_people_f ppf,
1257: hr_locations_all hl,
1258: hr_organization_units hou_org,
1259: per_assignment_status_types past,
1260: per_assignments_f paf
1261: where paf.assignment_id = ln_assignment_id
1262: and ld_effective_date between paf.effective_start_date
1263: and paf.effective_end_date
1264: and hou_org.organization_id = paf.organization_id