APPS.PSP_ENC_CREATE_LINES dependencies on PER_PAY_PROPOSALS

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

581: the earnings element and then it pro-rates the amount to
582: the window period of the active assignment chunk dates.
583:
584: Logic for Regular Salary element:
585: -- First, I will check if the element has a value in the PER_PAY_PROPOSALS.
586: -- If it does, then I will return the encumbrance amount on a per payroll period basis.
587: -- If the amount has not been defined, then I will look into the PAY_PAYWSMEE_ELEMENT_ENTRIES
588: -- table to obtain the amount.
589:

Line 704: FROM per_pay_proposals ppp,

700: NVL(ppb.pay_basis, ' ') pay_basis,
701: ppb.pay_annualization_factor,
702: paf.effective_start_date,
703: paf.effective_end_date
704: FROM per_pay_proposals ppp,
705: pay_input_values_f piv,
706: per_pay_bases ppb,
707: per_all_assignments_f paf,
708: per_assignment_status_types past

Line 712: FROM per_pay_proposals ppp1

708: per_assignment_status_types past
709: WHERE paf.assignment_id =p_assignment_id
710: AND ( ppp.change_date BETWEEN paf.effective_start_date AND paf.effective_end_date
711: OR ppp.change_date = (SELECT MAX(ppp1.change_date)
712: FROM per_pay_proposals ppp1
713: WHERE ppp1.assignment_id = p_assignment_id
714: AND ppp1.approved = 'Y'
715: AND ppp1.change_date <= paf.effective_start_date))
716: AND paf.pay_basis_id = ppb.pay_basis_id

Line 723: FROM per_pay_proposals ppp1

719: AND past.per_system_status = 'ACTIVE_ASSIGN'
720: AND piv.element_type_id +0 = p_element_type_id
721: AND ppp.approved = 'Y'
722: AND ((ppp.change_date >= (SELECT NVL(MAX(ppp1.change_date), l_min_start_date)
723: FROM per_pay_proposals ppp1
724: WHERE ppp1.assignment_id = p_assignment_id
725: AND ppp1.approved = 'Y'
726: AND ppp1.change_date <= l_min_start_date))
727: AND (ppp.change_date <= (SELECT NVL(MIN(ppp1.change_date), l_max_end_date + 1)

Line 728: FROM per_pay_proposals ppp1

724: WHERE ppp1.assignment_id = p_assignment_id
725: AND ppp1.approved = 'Y'
726: AND ppp1.change_date <= l_min_start_date))
727: AND (ppp.change_date <= (SELECT NVL(MIN(ppp1.change_date), l_max_end_date + 1)
728: FROM per_pay_proposals ppp1
729: WHERE ppp1.assignment_id = p_assignment_id
730: AND ppp1.approved = 'Y'
731: AND ppp1.change_date >= l_max_end_date)))
732: AND ppb.input_value_id = piv.input_value_id