DBA Data[Home] [Help]

APPS.PQH_GSP_STAGE_TO_BEN dependencies on PER_GRADES

Line 1333: ,P_MAPPING_TABLE_NAME => 'PER_GRADES'

1329: ,P_INCPTN_DT => r_PLN.INFORMATION306
1330: ,P_INVK_DCLN_PRTN_PL_FLAG => nvl(r_PLN.INFORMATION50,'N')
1331: ,P_INVK_FLX_CR_PL_FLAG => nvl(r_PLN.INFORMATION49,'N')
1332: ,P_IVR_IDENT => r_PLN.INFORMATION142
1333: ,P_MAPPING_TABLE_NAME => 'PER_GRADES'
1334: ,P_MAPPING_TABLE_PK_ID => r_PLN.INFORMATION294
1335: ,P_MAY_ENRL_PL_N_OIPL_FLAG => nvl(r_PLN.INFORMATION28,'N')
1336: ,P_MN_CVG_RL => r_PLN.INFORMATION283
1337: ,P_MN_CVG_RQD_AMT => r_PLN.INFORMATION300

Line 1845: FROM per_grades grd,

1841: --DN: Start code for BugId: 3242976
1842: begin
1843: SELECT grd.date_from
1844: INTO l_grd_effstdt
1845: FROM per_grades grd,
1846: ben_pl_f pln
1847: WHERE pln.pl_id = l_pl_id
1848: AND p_effective_date BETWEEN pln.effective_start_date
1849: AND pln.effective_end_date