[Home] [Help]
226: null, 1,
227: 0, 1,
228: ppb.pay_annualization_factor) * ppp.proposed_salary_n
229: ,petf.input_currency_code
230: FROM per_pay_bases ppb, per_assignments_f paf
231: ,per_pay_proposals ppp, pay_input_values_f ivf, pay_element_types_f petf
232: WHERE paf.person_id = p_person_id
233: AND paf.primary_flag = 'Y'
234: AND paf.assignment_type = 'E'
481:
482: select gr.currency_code, gr.minimum, gr.mid_value, gr.maximum, petf.input_currency_code,
483: pb.grade_annualization_factor, ppp.proposed_salary_n, pb.pay_annualization_factor
484: from pay_input_values_f ivf, pay_element_types_f petf, pay_grade_rules_f gr,
485: per_pay_bases pb, per_assignments_f paf, per_pay_proposals ppp
486: where paf.assignment_id = p_assignment_id
487: AND paf.pay_basis_id = pb.pay_basis_id
488: and paf.assignment_id = ppp.assignment_id(+)
489: and pb.input_value_id = ivf.input_value_id
736: FUNCTION getAsgGradeRule(p_pay_proposal_id IN NUMBER) RETURN ROWID IS
737: l_rowid ROWID:=NULL;
738: CURSOR c_graderule IS
739: SELECT gr.rowid
740: FROM per_pay_proposals ppp, per_assignments_f paf
741: ,per_pay_bases pb, pay_grade_rules_f gr
742: WHERE ppp.pay_proposal_id = p_pay_proposal_id
743: AND ppp.assignment_id = paf.assignment_id
744: AND ppp.change_date between paf.effective_start_date and paf.effective_end_date
826: ||
827: ||===========================================================================
828: */
829:
830: FUNCTION get_display_job_name(p_job_id IN per_assignments_f.job_id%TYPE)
831: RETURN VARCHAR2
832: IS
833:
834: l_name varchar2(100) ;
1101: CURSOR lc_get_lad (p_person_id IN per_people_f.person_id%TYPE)
1102: IS
1103: SELECT MAX(pa.date_received)
1104: FROM per_applications pa,
1105: per_assignments_f ass
1106: WHERE ass.application_id = pa.application_id
1107: AND ass.assignment_type = 'A'
1108: AND ass.person_id = p_person_id;
1109:
1247: ||
1248: ||===========================================================================
1249: */
1250:
1251: FUNCTION get_currency(p_assignment_id IN per_assignments_f.assignment_id%TYPE
1252: ,p_change_date IN DATE)
1253: RETURN pay_element_types_f.input_currency_code%TYPE
1254: IS
1255:
1254: IS
1255:
1256: lv_result pay_element_types_f.input_currency_code%TYPE;
1257:
1258: CURSOR lc_get_currency(p_assign_id IN per_assignments_f.assignment_id%TYPE
1259: ,p_change_date IN DATE)
1260: IS
1261: SELECT pet.input_currency_code
1262: FROM pay_element_types_f pet
1261: SELECT pet.input_currency_code
1262: FROM pay_element_types_f pet
1263: , pay_input_values_f piv
1264: , per_pay_bases ppb
1265: , per_assignments_f paf
1266: WHERE paf.assignment_id = p_assign_id
1267: AND p_change_date BETWEEN paf.effective_start_date
1268: AND paf.effective_end_date
1269: AND ppb.pay_basis_id = paf.pay_basis_id
1306: ||===========================================================================
1307: */
1308:
1309: FUNCTION get_annual_salary(
1310: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
1311: p_change_date IN DATE
1312: )
1313: RETURN VARCHAR2
1314: IS
1317: ln_annual_factor NUMBER;
1318: ln_proposed_salary NUMBER;
1319: lv_format_string VARCHAR2(30);
1320:
1321: CURSOR lc_get_salary(p_assign_id IN per_assignments_f.assignment_id%TYPE
1322: ,p_change_date IN DATE)
1323: IS
1324: SELECT ppb.pay_annualization_factor
1325: , ppp.proposed_salary_n
1323: IS
1324: SELECT ppb.pay_annualization_factor
1325: , ppp.proposed_salary_n
1326: FROM per_pay_bases ppb
1327: , per_assignments_f paf
1328: , per_pay_proposals ppp
1329: WHERE paf.assignment_id = p_assign_id
1330: AND p_change_date BETWEEN paf.effective_start_date
1331: AND NVL(paf.effective_end_date, p_change_date)
1382: ||
1383: ||===========================================================================
1384: */
1385:
1386: FUNCTION get_job(p_job_id IN per_assignments_f.job_id%TYPE)
1387: RETURN VARCHAR2
1388: IS
1389:
1390: -- Job Keyflex Id is stored in org_information6 in
1395: FROM hr_organization_information
1396: WHERE organization_id = p_business_group_id
1397: AND org_information_context = 'Business Group Information';
1398:
1399: CURSOR lc_get_job_details(p_job_id IN per_assignments_f.job_id%TYPE)
1400: IS
1401: SELECT pj.name,
1402: pjd.segment1,
1403: pjd.segment2,
1532: ||
1533: ||===========================================================================
1534: */
1535:
1536: FUNCTION get_grade(p_grade_id IN per_assignments_f.grade_id%TYPE)
1537: RETURN VARCHAR2
1538: IS
1539:
1540: -- Grade Keyflex Id is stored in org_information4 in
1545: FROM hr_organization_information
1546: WHERE organization_id = p_business_group_id
1547: AND org_information_context = 'Business Group Information';
1548:
1549: CURSOR lc_get_grade_details(p_grade_id IN per_assignments_f.grade_id%TYPE)
1550: IS
1551: SELECT pg.name,
1552: pgd.segment1,
1553: pgd.segment2,
1683: ||
1684: ||===========================================================================
1685: */
1686:
1687: FUNCTION get_position(p_position_id IN per_assignments_f.position_id%TYPE
1688: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
1689: RETURN VARCHAR2
1690: IS
1691:
1698: WHERE organization_id = p_business_group_id
1699: AND org_information_context = 'Business Group Information';
1700:
1701: CURSOR lc_get_position_details(
1702: p_position_id IN per_assignments_f.position_id%TYPE
1703: )
1704: IS
1705: SELECT pp.name,
1706: ppd.segment1,