APPS.PAY_NL_ABP_ARCHIVE dependencies on PAY_PAYWSMEE_PKG

Line 193: ,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id) date_earned

189: ,c_effective_date IN DATE
190: ,c_asg_id IN NUMBER) IS
191: --Retro entries
192: SELECT pei.eei_information12 sub_cat
193: ,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id) date_earned
194: ,decode (pei.eei_information12,'FPU_B','VPL','PPP','PPP-I','OPNP-I') pension_type
195: ,decode (pei.eei_information12,'OPNP_65','A','OPNP_W25','B','OPNP_W50','C') pension_type_variant
196: ,sum(fnd_number.canonical_to_number(peev.screen_entry_value)) contr_amt
197: ,pty.ee_contribution_bal_type_id

Line 251: AND pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id) >= g_valid_start_date

247: AND pet.business_group_id = c_bg_id
248: AND peef.assignment_id = c_asg_id
249: AND pei.eei_information12 IN ('OPNP_65','OPNP_W25','OPNP_W50','PPP','FPU_B')
250: AND pty.pension_type_id = to_number(pei.eei_information2)
251: AND pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id) >= g_valid_start_date
252: GROUP BY pei.eei_information12,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id)
253: ,pty.ee_contribution_bal_type_id,pty.er_contribution_bal_type_id
254: UNION
255: --Normal entries

Line 252: GROUP BY pei.eei_information12,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id)

248: AND peef.assignment_id = c_asg_id
249: AND pei.eei_information12 IN ('OPNP_65','OPNP_W25','OPNP_W50','PPP','FPU_B')
250: AND pty.pension_type_id = to_number(pei.eei_information2)
251: AND pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id) >= g_valid_start_date
252: GROUP BY pei.eei_information12,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id)
253: ,pty.ee_contribution_bal_type_id,pty.er_contribution_bal_type_id
254: UNION
255: --Normal entries
256: SELECT pension_sub_category sub_cat

Line 1091: AND pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id) BETWEEN c_orig_st_date

1087: AND pelf.element_type_id = c_ele_type_id
1088: AND peev.input_value_id = c_input_val_id
1089: AND peef.assignment_id = c_asg_id
1090: AND peev.screen_entry_value IS NOT NULL
1091: AND pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id) BETWEEN c_orig_st_date
1092: AND c_orig_ed_date;
1093: --=========================================================================
1094: CURSOR csr_get_hire_date(c_asg_id IN NUMBER) IS
1095: SELECT min (effective_start_date) hire_date

Line 1215: SELECT min (pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id)) start_date

1211: ,c_effective_date IN DATE
1212: ,c_ele_type_id IN NUMBER
1213: ,c_input_val_id IN NUMBER ) IS
1214:
1215: SELECT min (pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id)) start_date
1216: ,max (pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id)) end_date
1217: FROM pay_element_entries_f peef
1218: ,pay_element_links_f pelf
1219: ,pay_element_entry_values_f peev

Line 1216: ,max (pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id)) end_date

1212: ,c_ele_type_id IN NUMBER
1213: ,c_input_val_id IN NUMBER ) IS
1214:
1215: SELECT min (pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id)) start_date
1216: ,max (pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id)) end_date
1217: FROM pay_element_entries_f peef
1218: ,pay_element_links_f pelf
1219: ,pay_element_entry_values_f peev
1220: WHERE c_effective_date BETWEEN peef.effective_start_date

Line 1272: SELECT pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id) start_date

1268: CURSOR csr_get_retro_ptp(c_asg_id IN NUMBER
1269: ,c_effective_date IN DATE
1270: ,c_ele_type_id IN NUMBER
1271: ,c_input_val_id IN NUMBER ) IS
1272: SELECT pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id) start_date
1273: ,pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id) end_date
1274: ,fnd_number.canonical_to_number (peev.screen_entry_value) ptp
1275: FROM pay_element_entries_f peef
1276: ,pay_element_links_f pelf

Line 1273: ,pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id) end_date

1269: ,c_effective_date IN DATE
1270: ,c_ele_type_id IN NUMBER
1271: ,c_input_val_id IN NUMBER ) IS
1272: SELECT pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id) start_date
1273: ,pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id) end_date
1274: ,fnd_number.canonical_to_number (peev.screen_entry_value) ptp
1275: FROM pay_element_entries_f peef
1276: ,pay_element_links_f pelf
1277: ,pay_element_entry_values_f peev

Line 1516: ,pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id) date_earned

1512: CURSOR csr_get_retro_num_value(c_element_entry_id in number
1513: ,c_input_value_id in number) IS
1514: SELECT fnd_number.canonical_to_number (nvl (screen_entry_value
1515: ,'0')) amt
1516: ,pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id) date_earned
1517: FROM pay_element_entry_values_f
1518: WHERE element_entry_id = c_element_entry_id
1519: AND input_value_id = c_input_value_id;
1520: --=========================================================================

Line 1630: p_contr_basis_values(k).date_earned := trunc(pay_paywsmee_pkg.get_original_date_earned(temp_rec.element_entry_id),'MM'); --l_date_earned; --Bug 16301893

1626: p_contr_basis_values(k).pension_type := l_contr_basis(i).pension_type;
1627: p_contr_basis_values(k).pension_type_variant := NULL; --No pension type variant for AAOP/OPNP
1628: p_contr_basis_values(k).contr_base := l_retro_contr_basis.amt;
1629: p_contr_basis_values(k).contr_amt := NULL;
1630: p_contr_basis_values(k).date_earned := trunc(pay_paywsmee_pkg.get_original_date_earned(temp_rec.element_entry_id),'MM'); --l_date_earned; --Bug 16301893
1631:
1632: k := k + 1;
1633:
1634: END IF;