DBA Data[Home] [Help]

APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_FEEDS_F

Line 2435: FROM pay_balance_feeds_f pbf

2431: ,p_assgn_action_id NUMBER
2432: ,p_date_earned DATE
2433: ,p_si_type VARCHAR2) IS
2434: SELECT prrv1.result_value si_type_name
2435: FROM pay_balance_feeds_f pbf
2436: ,pay_balance_types pbt
2437: ,pay_input_values_f piv
2438: ,pay_input_values_f piv1
2439: ,pay_input_values_f piv2

Line 2927: pay_balance_feeds_f pbf,

2923: --Bug 7031784
2924: CURSOR csr_chk_corr_feeds (p_element_type_id NUMBER) IS
2925: SELECT pbt.balance_name
2926: FROM pay_balance_types pbt,
2927: pay_balance_feeds_f pbf,
2928: pay_input_values_f piv
2929: WHERE pbf.balance_type_id = pbt.balance_type_id
2930: AND piv.input_value_id = pbf.input_value_id
2931: AND piv.element_type_id = p_element_type_id

Line 3819: FROM pay_balance_feeds_f pbf

3815: ,p_assgn_action_id NUMBER
3816: ,p_date_earned DATE
3817: ,p_si_type VARCHAR2) IS
3818: SELECT prrv1.result_value si_type_name
3819: FROM pay_balance_feeds_f pbf
3820: ,pay_balance_types pbt
3821: ,pay_input_values_f piv
3822: ,pay_input_values_f piv1
3823: ,pay_input_values_f piv2

Line 4517: FROM pay_balance_feeds_f pbf

4513: ,p_special_bal_name VARCHAR2
4514: ,p_date_earned DATE
4515: ,p_classification_id NUMBER ) IS
4516: SELECT unique prr.start_date /*pay_nl_general.get_retro_period(prr.source_id,p_date_earned)*/ RDate -- Bug 5107780
4517: FROM pay_balance_feeds_f pbf
4518: ,pay_balance_types pbt
4519: ,pay_input_values_f piv
4520: ,pay_element_types_f pet
4521: ,pay_run_results prr

Line 4562: FROM pay_balance_feeds_f pbf

4558: ,p_creator_type VARCHAR2
4559: ,p_classification_id NUMBER ) IS
4560: SELECT sum(fnd_number.canonical_to_number(prrv.result_value)) result_value
4561: ,pet.processing_priority priority
4562: FROM pay_balance_feeds_f pbf
4563: ,pay_balance_types pbt
4564: ,pay_input_values_f piv
4565: ,pay_element_types_f pet
4566: -- ,pay_element_types_f_tl pettl Bug 5107780

Line 4607: FROM pay_balance_feeds_f pbf

4603: ,p_classification_id NUMBER) IS
4604: SELECT sum(fnd_number.canonical_to_number(prrv2.result_value))
4605: ,prrv1.result_value
4606: ,pet.processing_priority
4607: FROM pay_balance_feeds_f pbf
4608: ,pay_balance_types pbt
4609: ,pay_input_values_f piv
4610: ,pay_input_values_f piv1
4611: ,pay_input_values_f piv2