APPS.PSP_PAYTRN dependencies on PAY_ELEMENT_ENTRIES_F

Line 281: from pay_element_entries_f pee

277: pay_input_values_f piv
278: WHERE a.assignment_action_id = l_assignment_action_id and
279: SUBSTR(piv.uom, 1, 1) IN ('M', g_uom) AND
280: not exists ( select null
281: from pay_element_entries_f pee
282: where pee.element_entry_id = b.source_id and
283: pee.creator_type in ('RR','EE')) and
284: a.balance_or_cost = 'C' and
285: NVL(a.costed_value,0) <> 0 and

Line 323: from pay_element_entries_f pee

319: pay_input_values_f piv
320: WHERE a.assignment_action_id = l_assignment_action_id and
321: SUBSTR(piv.uom, 1, 1) IN ('M', g_uom) AND
322: exists ( select null
323: from pay_element_entries_f pee
324: where pee.element_entry_id = b.source_id and
325: pee.creator_type in ('RR','EE')) and
326: a.balance_or_cost = 'C' and
327: NVL(a.costed_value,0) <> 0 and

Line 515: FROM pay_element_entries_f

511: l_clearing_account_value VARCHAR2(1000);
512:
513: CURSOR ee_date_earned_cur IS
514: SELECT effective_start_date, effective_end_date,date_earned --LD Dev
515: FROM pay_element_entries_f
516: WHERE element_entry_id = g_pay_costs_rec.source_id;
517:
518: CURSOR emphours_config_cur IS
519: SELECT DECODE(pcv_information1, 'Y', 'H', 'M') employee_hours

Line 936: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||

932: IF (l_aw_column IS NOT NULL) THEN
933: BEGIN
934: EXECUTE IMMEDIATE 'SELECT ' || l_gl_column || ', ' || l_pt_column || ', ' ||
935: l_tk_column || ', ' || l_aw_column || ', ' || l_eo_column || ', ' || l_et_column ||
936: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||
937: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
938: INTO l_or_gl_ccid, l_or_project_id, l_or_task_id, l_or_award_id, l_or_expenditure_org_id, l_or_expenditure_type
939: USING g_pay_costs_rec.date_earned;
940: EXCEPTION

Line 948: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||

944: ELSE
945: BEGIN
946: EXECUTE IMMEDIATE 'SELECT ' || l_gl_column || ', ' || l_pt_column || ', ' ||
947: l_tk_column || ', ' || l_eo_column || ', ' || l_et_column ||
948: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||
949: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
950: INTO l_or_gl_ccid, l_or_project_id, l_or_task_id, l_or_expenditure_org_id, l_or_expenditure_type
951: USING g_pay_costs_rec.date_earned;
952: EXCEPTION

Line 960: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||

956: END IF;
957: ELSIF (l_gl_column IS NOT NULL) THEN
958: BEGIN
959: EXECUTE IMMEDIATE 'SELECT ' || l_gl_column ||
960: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||
961: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
962: INTO l_or_gl_ccid
963: USING g_pay_costs_rec.date_earned;
964: EXCEPTION

Line 973: ' FROM pay_element_entries_f WHERE element_entry_id = ' ||

969: IF (l_aw_column IS NOT NULL) THEN
970: BEGIN
971: EXECUTE IMMEDIATE 'SELECT ' || l_pt_column || ', ' || l_tk_column || ', ' ||
972: l_aw_column || ', ' || l_eo_column || ', ' || l_et_column ||
973: ' FROM pay_element_entries_f WHERE element_entry_id = ' ||
974: g_pay_costs_rec.source_id ||
975: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
976: INTO l_or_project_id, l_or_task_id, l_or_award_id, l_or_expenditure_org_id, l_or_expenditure_type
977: USING g_pay_costs_rec.date_earned;

Line 986: ' FROM pay_element_entries_f WHERE element_entry_id = ' ||

982: ELSE
983: BEGIN
984: EXECUTE IMMEDIATE 'SELECT ' || l_pt_column || ', ' || l_tk_column || ', ' ||
985: l_eo_column || ', ' || l_et_column ||
986: ' FROM pay_element_entries_f WHERE element_entry_id = ' ||
987: g_pay_costs_rec.source_id ||
988: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
989: INTO l_or_project_id, l_or_task_id, l_or_expenditure_org_id, l_or_expenditure_type
990: USING g_pay_costs_rec.date_earned;