APPS.PAY_ZA_EOY_VAL dependencies on PAY_ZA_IRP5_BAL_CODES

Line 384: FROM pay_za_irp5_bal_codes irp5,

380:
381: CURSOR negative_amt_check_cur(p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
382: select irp5.code,
383: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
384: FROM pay_za_irp5_bal_codes irp5,
385: ff_archive_items arc,
386: ff_database_items dbi
387: WHERE dbi.user_entity_id = arc.user_entity_id
388: and irp5.user_name = dbi.user_name

Line 437: FROM pay_za_irp5_bal_codes irp5,

433: /* Cursor to fetch all LumpSum Balance Sars Codes ( For Main Certificate) which have neagtive amounts*/
434: CURSOR fetch_lmpsm_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) is
435: select irp5.code,
436: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
437: FROM pay_za_irp5_bal_codes irp5,
438: ff_archive_items arc,
439: ff_database_items dbi,
440: ff_archive_item_contexts faic2,
441: ff_contexts ffc2

Line 460: from pay_za_irp5_bal_codes irp5,

456: CURSOR get_lmpsm_crt_bal (p_asg_act_id pay_assignment_actions.assignment_action_id%TYPE) is
457: select sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(arc.value)))) value
458: , faic2.CONTEXT Tax_Directive_Number
459: , irp5.code code
460: from pay_za_irp5_bal_codes irp5,
461: ff_archive_items arc,
462: ff_database_items dbi,
463: ff_archive_item_contexts faic2,
464: ff_contexts ffc2

Line 498: FROM pay_za_irp5_bal_codes irp5,

494: CURSOR fetch_deduction_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%type) IS
495: select irp5.code ,
496: faic2.CONTEXT clearance_num,
497: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
498: FROM pay_za_irp5_bal_codes irp5,
499: ff_archive_items arc,
500: ff_database_items dbi,
501: ff_archive_item_contexts faic2,
502: ff_contexts ffc2

Line 522: FROM pay_za_irp5_bal_codes irp5,

518: /*Cursor to fetch Medical Aid Code Values for Cross Validation*/
519: CURSOR fetch_med_code_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
520: select irp5.code,
521: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
522: FROM pay_za_irp5_bal_codes irp5,
523: ff_archive_items arc,
524: ff_database_items dbi
525: WHERE irp5.code IN (3810, 3813, 4005, 4024, 4025, 4485, 4486)
526: AND irp5.balance_sequence = 1

Line 586: FROM pay_za_irp5_bal_codes irp5,

582: select irp5.code,
583: irp5.full_balance_name bal_name,
584: irp5.balance_type_id bal_type_id,
585: trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)))) value
586: FROM pay_za_irp5_bal_codes irp5,
587: ff_archive_items arc,
588: ff_database_items dbi,
589: per_assignment_extra_info paei,
590: pay_assignment_actions paa

Line 737: pay_za_irp5_bal_codes irp5

733: CURSOR chk_rtrmnt_fnd_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
734: SELECT irp5.code, sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
735: FROM ff_archive_items arc,
736: ff_database_items dbi,
737: pay_za_irp5_bal_codes irp5
738: WHERE arc.user_entity_id = dbi.user_entity_id
739: and irp5.user_name = dbi.user_name
740: and arc.context1 in (p_asgn_action_id)
741: and code in (3915,4115)