[Home] [Help]
474: -- get_bg_and_leg_info --
475: -- Purpose --
476: -- 1.Retrieves keyflex structure for the legislations SCL and also for the --
477: -- costing keyflex for the business group. --
478: -- 2.Looks for rules in PAY_LEGISLATION_RULES for the disabling of --
479: -- update of time period --
480: -- dates ie. some legislations require that some dates cannot be changed --
481: -- eg. cannot update the regular payment date etc... --
482: -- 3.Looks for rule in PAY_LEGISLATION_RULES which determines whether --
478: -- 2.Looks for rules in PAY_LEGISLATION_RULES for the disabling of --
479: -- update of time period --
480: -- dates ie. some legislations require that some dates cannot be changed --
481: -- eg. cannot update the regular payment date etc... --
482: -- 3.Looks for rule in PAY_LEGISLATION_RULES which determines whether --
483: -- the pay offset date must be negative or whether it can be negative --
484: -- or positive.
485: -- Arguments --
486: -- p_regular_payment_date --
489: -- p_cut_off_date --
490: -- p_pay_date_offset_rule
491: -- p_payslip_view_date by rajeesha bug 4246280
492: -- Notes --
493: -- The existence of a row in PAY_LEGISLATION_RULES with a RULE_TYPE as --
494: -- shown below means that the date is disabled ie. cannot be updated. --
495: -- RULE_TYPE DATE --
496: -- P REGULAR_PAYMENT_DATE --
497: -- C CUT_OFF_DATE --
524: --
525: cursor csr_leg_rules is
526: select lr.rule_type,
527: lr.rule_mode
528: from pay_legislation_rules lr
529: where lr.legislation_code = p_legislation_code;
530: --
531: cursor csr_leg_rules2 is
532: select lr.rule_type,
3114: )
3115: IS
3116: CURSOR c_advance_pay IS
3117: SELECT 'X'
3118: FROM pay_legislation_rules
3119: WHERE legislation_code = p_legislation_code
3120: AND rule_type = 'ADVANCE';
3121:
3122: l_lookup_type varchar2(80);