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 703: per_assignments_f paf,

699: ,paf.assignment_number
700: ,paf.employment_category
701: from pay_payroll_actions ppa,
702: pay_assignment_actions paa,
703: per_assignments_f paf,
704: per_people_f ppf,
705: pay_payrolls_f pf,
706: fnd_common_lookups fcl
707: where ppa.action_type in ('R', 'Q', 'B', 'I', 'V')

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

1024: lv_org_name VARCHAR2(240);
1025: lv_payroll_name VARCHAR2(100);
1026: lv_location_code VARCHAR2(60);
1027: lv_assignment_status VARCHAR2(100);
1028: lv_employment_category_code per_assignments_f.employment_category%type; --Bug 3650988
1029: lv_employment_category VARCHAR2(100);
1030:
1031: lv_element_name VARCHAR2(100);
1032: lv_element_value VARCHAR2(100);

Line 1269: per_assignments_f paf

1265: per_people_f ppf,
1266: hr_locations_all hl,
1267: hr_organization_units hou_org,
1268: per_assignment_status_types past,
1269: per_assignments_f paf
1270: where paf.assignment_id = ln_assignment_id
1271: and ld_effective_date between paf.effective_start_date
1272: and paf.effective_end_date
1273: and hou_org.organization_id = paf.organization_id