DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on PAY_ALL_PAYROLLS_F

Line 256: g_payroll pay_all_payrolls_f.payroll_name%TYPE;

252: --
253:
254: g_job per_jobs.name%TYPE;
255: g_position per_positions.name%TYPE;
256: g_payroll pay_all_payrolls_f.payroll_name%TYPE;
257: g_people_group pay_people_groups.group_name%TYPE;
258: g_pay_basis per_pay_bases.name%TYPE;
259: g_pay_basis_type per_pay_bases.pay_basis%TYPE;
260: --

Line 267: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

263: g_employee_organization_id per_all_organization_units.organization_id%TYPE;
264: g_location_id hr_locations.location_id%TYPE;
265: g_job_id per_jobs.job_id%TYPE;
266: g_position_id per_positions.position_id%TYPE;
267: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
268: g_people_group_id pay_people_groups.people_group_id%TYPE;
269: g_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
270: g_payroll_period_type pay_all_payrolls_f.period_type%TYPE;
271: g_payroll_period_number per_time_periods.period_num%TYPE;

Line 270: g_payroll_period_type pay_all_payrolls_f.period_type%TYPE;

266: g_position_id per_positions.position_id%TYPE;
267: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
268: g_people_group_id pay_people_groups.people_group_id%TYPE;
269: g_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
270: g_payroll_period_type pay_all_payrolls_f.period_type%TYPE;
271: g_payroll_period_number per_time_periods.period_num%TYPE;
272: g_payroll_period_strtdt per_time_periods.start_date%TYPE;
273: g_payroll_period_enddt per_time_periods.end_date%TYPE;
274: g_payroll_costing pay_cost_allocation_keyflex.concatenated_segments%TYPE;

Line 1071: g_prl_flex_01 pay_all_payrolls_f.attribute1%TYPE;

1067: g_alc_flex_08 hr_locations.attribute8%TYPE;
1068: g_alc_flex_09 hr_locations.attribute9%TYPE;
1069: g_alc_flex_10 hr_locations.attribute10%TYPE;
1070: --
1071: g_prl_flex_01 pay_all_payrolls_f.attribute1%TYPE;
1072: g_prl_flex_02 pay_all_payrolls_f.attribute2%TYPE;
1073: g_prl_flex_03 pay_all_payrolls_f.attribute3%TYPE;
1074: g_prl_flex_04 pay_all_payrolls_f.attribute4%TYPE;
1075: g_prl_flex_05 pay_all_payrolls_f.attribute5%TYPE;

Line 1072: g_prl_flex_02 pay_all_payrolls_f.attribute2%TYPE;

1068: g_alc_flex_09 hr_locations.attribute9%TYPE;
1069: g_alc_flex_10 hr_locations.attribute10%TYPE;
1070: --
1071: g_prl_flex_01 pay_all_payrolls_f.attribute1%TYPE;
1072: g_prl_flex_02 pay_all_payrolls_f.attribute2%TYPE;
1073: g_prl_flex_03 pay_all_payrolls_f.attribute3%TYPE;
1074: g_prl_flex_04 pay_all_payrolls_f.attribute4%TYPE;
1075: g_prl_flex_05 pay_all_payrolls_f.attribute5%TYPE;
1076: g_prl_flex_06 pay_all_payrolls_f.attribute6%TYPE;

Line 1073: g_prl_flex_03 pay_all_payrolls_f.attribute3%TYPE;

1069: g_alc_flex_10 hr_locations.attribute10%TYPE;
1070: --
1071: g_prl_flex_01 pay_all_payrolls_f.attribute1%TYPE;
1072: g_prl_flex_02 pay_all_payrolls_f.attribute2%TYPE;
1073: g_prl_flex_03 pay_all_payrolls_f.attribute3%TYPE;
1074: g_prl_flex_04 pay_all_payrolls_f.attribute4%TYPE;
1075: g_prl_flex_05 pay_all_payrolls_f.attribute5%TYPE;
1076: g_prl_flex_06 pay_all_payrolls_f.attribute6%TYPE;
1077: g_prl_flex_07 pay_all_payrolls_f.attribute7%TYPE;

Line 1074: g_prl_flex_04 pay_all_payrolls_f.attribute4%TYPE;

1070: --
1071: g_prl_flex_01 pay_all_payrolls_f.attribute1%TYPE;
1072: g_prl_flex_02 pay_all_payrolls_f.attribute2%TYPE;
1073: g_prl_flex_03 pay_all_payrolls_f.attribute3%TYPE;
1074: g_prl_flex_04 pay_all_payrolls_f.attribute4%TYPE;
1075: g_prl_flex_05 pay_all_payrolls_f.attribute5%TYPE;
1076: g_prl_flex_06 pay_all_payrolls_f.attribute6%TYPE;
1077: g_prl_flex_07 pay_all_payrolls_f.attribute7%TYPE;
1078: g_prl_flex_08 pay_all_payrolls_f.attribute8%TYPE;

Line 1075: g_prl_flex_05 pay_all_payrolls_f.attribute5%TYPE;

1071: g_prl_flex_01 pay_all_payrolls_f.attribute1%TYPE;
1072: g_prl_flex_02 pay_all_payrolls_f.attribute2%TYPE;
1073: g_prl_flex_03 pay_all_payrolls_f.attribute3%TYPE;
1074: g_prl_flex_04 pay_all_payrolls_f.attribute4%TYPE;
1075: g_prl_flex_05 pay_all_payrolls_f.attribute5%TYPE;
1076: g_prl_flex_06 pay_all_payrolls_f.attribute6%TYPE;
1077: g_prl_flex_07 pay_all_payrolls_f.attribute7%TYPE;
1078: g_prl_flex_08 pay_all_payrolls_f.attribute8%TYPE;
1079: g_prl_flex_09 pay_all_payrolls_f.attribute9%TYPE;

Line 1076: g_prl_flex_06 pay_all_payrolls_f.attribute6%TYPE;

1072: g_prl_flex_02 pay_all_payrolls_f.attribute2%TYPE;
1073: g_prl_flex_03 pay_all_payrolls_f.attribute3%TYPE;
1074: g_prl_flex_04 pay_all_payrolls_f.attribute4%TYPE;
1075: g_prl_flex_05 pay_all_payrolls_f.attribute5%TYPE;
1076: g_prl_flex_06 pay_all_payrolls_f.attribute6%TYPE;
1077: g_prl_flex_07 pay_all_payrolls_f.attribute7%TYPE;
1078: g_prl_flex_08 pay_all_payrolls_f.attribute8%TYPE;
1079: g_prl_flex_09 pay_all_payrolls_f.attribute9%TYPE;
1080: g_prl_flex_10 pay_all_payrolls_f.attribute10%TYPE;

Line 1077: g_prl_flex_07 pay_all_payrolls_f.attribute7%TYPE;

1073: g_prl_flex_03 pay_all_payrolls_f.attribute3%TYPE;
1074: g_prl_flex_04 pay_all_payrolls_f.attribute4%TYPE;
1075: g_prl_flex_05 pay_all_payrolls_f.attribute5%TYPE;
1076: g_prl_flex_06 pay_all_payrolls_f.attribute6%TYPE;
1077: g_prl_flex_07 pay_all_payrolls_f.attribute7%TYPE;
1078: g_prl_flex_08 pay_all_payrolls_f.attribute8%TYPE;
1079: g_prl_flex_09 pay_all_payrolls_f.attribute9%TYPE;
1080: g_prl_flex_10 pay_all_payrolls_f.attribute10%TYPE;
1081: --

Line 1078: g_prl_flex_08 pay_all_payrolls_f.attribute8%TYPE;

1074: g_prl_flex_04 pay_all_payrolls_f.attribute4%TYPE;
1075: g_prl_flex_05 pay_all_payrolls_f.attribute5%TYPE;
1076: g_prl_flex_06 pay_all_payrolls_f.attribute6%TYPE;
1077: g_prl_flex_07 pay_all_payrolls_f.attribute7%TYPE;
1078: g_prl_flex_08 pay_all_payrolls_f.attribute8%TYPE;
1079: g_prl_flex_09 pay_all_payrolls_f.attribute9%TYPE;
1080: g_prl_flex_10 pay_all_payrolls_f.attribute10%TYPE;
1081: --
1082: g_pos_flex_01 per_positions.attribute1%TYPE;

Line 1079: g_prl_flex_09 pay_all_payrolls_f.attribute9%TYPE;

1075: g_prl_flex_05 pay_all_payrolls_f.attribute5%TYPE;
1076: g_prl_flex_06 pay_all_payrolls_f.attribute6%TYPE;
1077: g_prl_flex_07 pay_all_payrolls_f.attribute7%TYPE;
1078: g_prl_flex_08 pay_all_payrolls_f.attribute8%TYPE;
1079: g_prl_flex_09 pay_all_payrolls_f.attribute9%TYPE;
1080: g_prl_flex_10 pay_all_payrolls_f.attribute10%TYPE;
1081: --
1082: g_pos_flex_01 per_positions.attribute1%TYPE;
1083: g_pos_flex_02 per_positions.attribute2%TYPE;

Line 1080: g_prl_flex_10 pay_all_payrolls_f.attribute10%TYPE;

1076: g_prl_flex_06 pay_all_payrolls_f.attribute6%TYPE;
1077: g_prl_flex_07 pay_all_payrolls_f.attribute7%TYPE;
1078: g_prl_flex_08 pay_all_payrolls_f.attribute8%TYPE;
1079: g_prl_flex_09 pay_all_payrolls_f.attribute9%TYPE;
1080: g_prl_flex_10 pay_all_payrolls_f.attribute10%TYPE;
1081: --
1082: g_pos_flex_01 per_positions.attribute1%TYPE;
1083: g_pos_flex_02 per_positions.attribute2%TYPE;
1084: g_pos_flex_03 per_positions.attribute3%TYPE;

Line 1273: g_CWB_Person_PAYROLL_NAME pay_all_payrolls_f.payroll_name%TYPE;

1269: g_CWB_Person_ORG_name per_all_organization_units.name%TYPE;
1270: g_CWB_Person_ORIG_START_DATE ben_cwb_person_info.ORIGINAL_START_DATE%type ;
1271: g_CWB_Person_PAY_RATE varchar2(100) ;
1272: g_CWB_Person_PAY_ANNUL_FACTOR ben_cwb_person_info.PAY_ANNULIZATION_FACTOR%type ;
1273: g_CWB_Person_PAYROLL_NAME pay_all_payrolls_f.payroll_name%TYPE;
1274: g_CWB_Person_PERF_RATING_DATE ben_cwb_person_info.PERFORMANCE_RATING%type ;
1275: g_CWB_Person_POSITION per_positions.name%type ;
1276: g_CWB_Person_STATUS_TYPE varchar2(250) ;
1277: g_CWB_Person_SUP_BRIEF_NAME ben_cwb_person_info.SUPERVISOR_BRIEF_NAME%type ;