DBA Data[Home] [Help]

APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PQP_GB_PSI_EARNINGS_HISTORY

Line 1: PACKAGE BODY PQP_GB_PSI_EARNINGS_HISTORY

1: PACKAGE BODY PQP_GB_PSI_EARNINGS_HISTORY
2: -- /* $Header: pqpgbpsiern.pkb 120.28.12020000.3 2012/07/05 12:09:39 amnaraya ship $ */
3: AS
4: -- ----------------------------------------------------------------------------
5: -- |--------------------------------< debug >---------------------------------|

Line 5539: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';

5535: p_ptd_balance => TRUE);
5536:
5537: IF l_current_earnings <> 0
5538: THEN
5539: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';
5540: END IF;
5541:
5542: END IF; --l_check_current_balance = 'Y'
5543:

Line 5572: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';

5568: p_ptd_balance => TRUE);
5569:
5570: IF l_current_earnings <> 0
5571: THEN
5572: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';
5573: END IF;
5574:
5575: END IF; --End if l_check_current_balance = 'Y'
5576:

Line 5641: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';

5637: ,p_virtual_date => l_effective_end_date); */
5638:
5639: IF l_current_earnings <> 0
5640: THEN
5641: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';
5642: END IF;
5643:
5644: END IF; --End if l_check_current_balance = 'Y'
5645:

Line 5676: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';

5672: p_ptd_balance => TRUE);
5673:
5674: IF l_current_earnings <> 0
5675: THEN
5676: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';
5677: END IF;
5678:
5679: END IF; --End if l_check_current_balance = 'Y'
5680:

Line 5711: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';

5707: ,p_ptd_balance => TRUE);
5708:
5709: IF l_current_earnings <> 0
5710: THEN
5711: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';
5712: END IF;
5713:
5714: END IF; --End if l_check_current_balance = 'Y'
5715:

Line 5742: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';

5738: p_ptd_balance => TRUE);
5739:
5740: IF l_current_earnings <> 0
5741: THEN
5742: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';
5743: END IF;
5744:
5745: END IF; --l_check_current_balance = 'Y'
5746:

Line 5809: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';

5805: ,p_virtual_date => l_effective_end_date); */
5806:
5807: IF l_current_earnings <> 0
5808: THEN
5809: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';
5810: END IF;
5811:
5812: END IF; --End if l_check_current_balance = 'Y'
5813:

Line 5948: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';

5944: );
5945:
5946: IF l_current_earnings <> 0
5947: THEN
5948: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';
5949: END IF;
5950:
5951: END IF; --l_check_current_balance = 'Y'
5952:

Line 6022: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';

6018: );
6019:
6020: IF l_current_earnings <> 0
6021: THEN
6022: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';
6023: END IF;
6024:
6025: END IF; --l_check_current_balance = 'Y'
6026:

Line 6097: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';

6093: );
6094:
6095: IF l_current_earnings <> 0
6096: THEN
6097: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';
6098: END IF;
6099:
6100: END IF; --l_check_current_balance = 'Y'
6101: END IF; -- g_member = 'Y'

Line 6205: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';

6201: ,p_virtual_date => l_effective_end_date); */
6202:
6203: IF l_current_earnings <> 0
6204: THEN
6205: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';
6206: END IF;
6207:
6208: END IF;
6209:

Line 6277: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';

6273: ,p_virtual_date => l_effective_end_date); */
6274:
6275: IF l_current_earnings <> 0
6276: THEN
6277: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';
6278: END IF;
6279:
6280: END IF;
6281:

Line 6324: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';

6320: );
6321:
6322: IF l_current_earnings <> 0
6323: THEN
6324: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'N';
6325: END IF;
6326:
6327: END IF; --l_check_current_balance = 'Y'
6328:

Line 6346: IF pqp_gb_psi_earnings_history.g_ern_term_exclude_flag = 'Y' and l_check_current_balance = 'Y'

6342:
6343: -- For Bug 5941475
6344: ELSIF p_rule_parameter = 'Check' THEN
6345:
6346: IF pqp_gb_psi_earnings_history.g_ern_term_exclude_flag = 'Y' and l_check_current_balance = 'Y'
6347: THEN
6348: l_return_value := NULL;
6349: ELSE
6350: l_return_value := 'INCLUDE';

Line 6353: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'Y';

6349: ELSE
6350: l_return_value := 'INCLUDE';
6351: END IF;
6352:
6353: pqp_gb_psi_earnings_history.g_ern_term_exclude_flag := 'Y';
6354:
6355: END IF; -- End if of rule parameter check ...
6356:
6357: IF NOT l_earnings BETWEEN -99999999.99 AND 999999999.99

Line 6453: END pqp_gb_psi_earnings_history;

6449: ELSE
6450: RAISE;
6451: END IF;
6452: END earnings_history_post_process;
6453: END pqp_gb_psi_earnings_history;