APPS.JAI_FBT_PROCESS_P dependencies on JAI_FBT_SETUP_LINES

Line 546: jai_fbt_setup_lines line

542: , head.surcharge_rate
543: , head.edu_cess_rate
544: , head.sh_cess_rate
545: FROM
546: jai_fbt_setup_lines line
547: , jai_fbt_setup_headers head
548: WHERE line.legal_entity_id = pn_legal_entity_id
549: AND line.legal_entity_id = head.legal_entity_id
550: --modified by lvxiao for R12 new changegs on 06-Nov-2008, begin

Line 1206: FROM jai_fbt_setup_lines

1202: AND ( ( NVL(accrue_on_receipt_flag, 'N') = 'N'
1203: AND Get_Natural_Acc_Seg( pv_nat_acc_seg
1204: , det.DIST_CODE_COMBINATION_id
1205: ) IN ( SELECT NATURAL_ACCOUNT_VALUE
1206: FROM jai_fbt_setup_lines
1207: WHERE legal_entity_id = pn_legal_entity_id
1208: AND fbt_year = pn_fbt_year
1209: AND FRINGE_BENEFIT_TYPE_CODE
1210: = NVL(pv_fringe_benefit_type_code

Line 1295: jai_fbt_setup_lines

1291: , det.DIST_CODE_COMBINATION_id
1292: ) IN ( SELECT
1293: NATURAL_ACCOUNT_VALUE
1294: FROM
1295: jai_fbt_setup_lines
1296: WHERE legal_entity_id = pn_legal_entity_id
1297: AND fbt_year = pn_fbt_year
1298: AND FRINGE_BENEFIT_TYPE_CODE =
1299: NVL( pv_fringe_benefit_type_code

Line 1359: FROM jai_fbt_setup_lines

1355: AND head.JE_BATCH_ID = batch.JE_BATCH_ID
1356: AND Get_Natural_Acc_Seg( pv_nat_acc_seg
1357: , line.CODE_COMBINATION_ID
1358: ) IN ( SELECT NATURAL_ACCOUNT_VALUE
1359: FROM jai_fbt_setup_lines
1360: WHERE legal_entity_id = pn_legal_entity_id
1361: AND fbt_year = pn_fbt_year
1362: AND FRINGE_BENEFIT_TYPE_CODE =
1363: NVL( pv_fringe_benefit_type_code

Line 1399: jai_fbt_setup_lines

1395: IS
1396: SELECT
1397: fringe_benefit_type_code
1398: FROM
1399: jai_fbt_setup_lines
1400: WHERE natural_account_value = pn_nat_account
1401: AND legal_entity_id = pn_legal_entity_id
1402: --modified by lvxiao for R12 new change on 06-Nov-2008, begin
1403: -----------------------------------------------------------------------------------