APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PER_PAY_BASES

Line 195: per_pay_bases ppb,

191: hr_all_positions_f pp ,
192: per_shared_types pst ,
193: per_all_assignments_f paf ,
194: pay_all_payrolls_f ppay,
195: per_pay_bases ppb,
196: per_assignment_status_types past --bug 4020452
197: WHERE fs.session_id = userenv('sessionid')
198: AND fs.effective_date between pp.effective_start_date
199: and pp.effective_end_date

Line 386: FROM PER_PAY_BASES

382: AND business_group_id = p_business_group_id;
383:
384: Cursor C_pay_basis is
385: SELECT pay_basis
386: FROM PER_PAY_BASES
387: WHERE pay_basis_id = l_pay_basis_id;
388:
389: --
390: -- Cursor to find the list of assignment_status types

Line 1079: FROM PAY_RATES pr, PER_PAY_BASES ppb, PAY_INPUT_VALUES piv

1075: AND business_group_id = p_business_group_id;
1076: --
1077: Cursor C_paybasis is
1078: SELECT pay_basis, piv.element_type_id
1079: FROM PAY_RATES pr, PER_PAY_BASES ppb, PAY_INPUT_VALUES piv
1080: WHERE pr.parent_spine_id = l_rate_or_payscale_id
1081: AND pr.rate_id = ppb.rate_id
1082: AND pr.business_group_id = p_business_group_id
1083: AND ppb.business_group_id = p_business_group_id

Line 1111: FROM PER_PAY_BASES ppb, PAY_INPUT_VALUES piv

1107:
1108: --
1109: Cursor C_rate_paybasis is
1110: SELECT ppb.pay_basis, piv.element_type_id
1111: FROM PER_PAY_BASES ppb, PAY_INPUT_VALUES piv
1112: WHERe ppb.rate_id = l_rate_id
1113: AND ppb.business_group_id = p_business_group_id
1114: AND ppb.input_value_id = piv.input_value_id;
1115: --

Line 1270: -- To get Pay Basis from per_pay_bases

1266: END IF;
1267:
1268: End Loop;
1269:
1270: -- To get Pay Basis from per_pay_bases
1271: For C_paybasis_rec in C_rate_paybasis
1272: Loop
1273: l_pay_basis := C_paybasis_rec.pay_basis;
1274: l_element_type_id := C_paybasis_rec.element_type_id;

Line 1402: -- To get Pay Basis from per_pay_bases

1398: l_rate_or_payscale_name := SUBSTR(l_rate_or_payscale_name,1,30) ;
1399: END IF;
1400: End Loop;
1401:
1402: -- To get Pay Basis from per_pay_bases
1403: For C_paybasis_rec in C_rate_paybasis
1404: Loop
1405: l_pay_basis := C_paybasis_rec.pay_basis;
1406: l_element_type_id := C_paybasis_rec.element_type_id;

Line 1703: per_pay_bases ppb

1699: /* End bug #4128475 */
1700: per_all_assignments_f paf,
1701: per_all_people_f ppf,
1702: pay_all_payrolls_f ppay,
1703: per_pay_bases ppb
1704: WHERE fs.session_id = userenv('sessionid')
1705: AND fs.effective_date between paf.effective_start_date and paf.effective_end_date
1706: AND pp.data_extract_id = p_data_extract_id
1707: AND pp.hr_position_id = paf.position_id

Line 2418: per_pay_bases ppb

2414:
2415: Cursor C_Pay_basis is
2416: Select element_type_id
2417: from pay_input_values piv,
2418: per_pay_bases ppb
2419: where ppb.pay_basis_id = le_pay_basis_id
2420: and piv.input_value_id = ppb.input_value_id;
2421:
2422: Cursor C_Element is

Line 2854: per_pay_bases ppb,

2850:
2851: Cursor C_Element_Type is
2852: Select element_type_id
2853: from fnd_sessions fs, pay_input_values piv,
2854: per_pay_bases ppb,
2855: per_all_assignments_f paf
2856: where fs.session_id = userenv('sessionid')
2857: and fs.effective_date between paf.effective_start_date and paf.effective_end_date
2858: and paf.assignment_id = p_assignment_id