APPS.PSP_ENC_CREATE_LINES dependencies on PER_PAY_PROPOSALS

Line 787: -- First, I will check if the element has a value in the PER_PAY_PROPOSALS.

783: the earnings element and then it pro-rates the amount to
784: the window period of the active assignment chunk dates.
785:
786: Logic for Regular Salary element:
787: -- First, I will check if the element has a value in the PER_PAY_PROPOSALS.
788: -- If it does, then I will return the encumbrance amount on a per payroll period basis.
789: -- If the amount has not been defined, then I will look into the PAY_PAYWSMEE_ELEMENT_ENTRIES
790: -- table to obtain the amount.
791:

Line 906: FROM per_pay_proposals ppp,

902: NVL(ppb.pay_basis, ' ') pay_basis,
903: ppb.pay_annualization_factor,
904: paf.effective_start_date,
905: paf.effective_end_date
906: FROM per_pay_proposals ppp,
907: pay_input_values_f piv,
908: per_pay_bases ppb,
909: per_all_assignments_f paf,
910: per_assignment_status_types past

Line 914: FROM per_pay_proposals ppp1

910: per_assignment_status_types past
911: WHERE paf.assignment_id =p_assignment_id
912: AND ( ppp.change_date BETWEEN paf.effective_start_date AND paf.effective_end_date
913: OR ppp.change_date = (SELECT MAX(ppp1.change_date)
914: FROM per_pay_proposals ppp1
915: WHERE ppp1.assignment_id = p_assignment_id
916: AND ppp1.approved = 'Y'
917: AND ppp1.change_date <= paf.effective_start_date))
918: AND paf.pay_basis_id = ppb.pay_basis_id

Line 925: FROM per_pay_proposals ppp1

921: AND past.per_system_status = 'ACTIVE_ASSIGN'
922: AND piv.element_type_id +0 = p_element_type_id
923: AND ppp.approved = 'Y'
924: AND ((ppp.change_date >= (SELECT NVL(MAX(ppp1.change_date), l_min_start_date)
925: FROM per_pay_proposals ppp1
926: WHERE ppp1.assignment_id = p_assignment_id
927: AND ppp1.approved = 'Y'
928: AND ppp1.change_date <= l_min_start_date))
929: AND (ppp.change_date <= (SELECT NVL(MIN(ppp1.change_date), l_max_end_date + 1)

Line 930: FROM per_pay_proposals ppp1

926: WHERE ppp1.assignment_id = p_assignment_id
927: AND ppp1.approved = 'Y'
928: AND ppp1.change_date <= l_min_start_date))
929: AND (ppp.change_date <= (SELECT NVL(MIN(ppp1.change_date), l_max_end_date + 1)
930: FROM per_pay_proposals ppp1
931: WHERE ppp1.assignment_id = p_assignment_id
932: AND ppp1.approved = 'Y'
933: AND ppp1.change_date >= l_max_end_date)))
934: AND ppb.input_value_id = piv.input_value_id