DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on PAY_ALL_PAYROLLS_F

Line 253: g_payroll pay_all_payrolls_f.payroll_name%TYPE;

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

Line 264: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

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

Line 267: g_payroll_period_type pay_all_payrolls_f.period_type%TYPE;

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

Line 1068: g_prl_flex_01 pay_all_payrolls_f.attribute1%TYPE;

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

Line 1069: g_prl_flex_02 pay_all_payrolls_f.attribute2%TYPE;

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

Line 1070: g_prl_flex_03 pay_all_payrolls_f.attribute3%TYPE;

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

Line 1071: g_prl_flex_04 pay_all_payrolls_f.attribute4%TYPE;

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

Line 1072: g_prl_flex_05 pay_all_payrolls_f.attribute5%TYPE;

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

Line 1073: g_prl_flex_06 pay_all_payrolls_f.attribute6%TYPE;

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

Line 1074: g_prl_flex_07 pay_all_payrolls_f.attribute7%TYPE;

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

Line 1075: g_prl_flex_08 pay_all_payrolls_f.attribute8%TYPE;

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

Line 1076: g_prl_flex_09 pay_all_payrolls_f.attribute9%TYPE;

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

Line 1077: g_prl_flex_10 pay_all_payrolls_f.attribute10%TYPE;

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

Line 1270: g_CWB_Person_PAYROLL_NAME pay_all_payrolls_f.payroll_name%TYPE;

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