DBA Data[Home] [Help]

APPS.PSP_AUTOPOP dependencies on PSP_AUTO_RULES

Line 613: (SELECT '1' from psp_auto_rules where acct_id=a.acct_id)

609: AND p_payroll_date BETWEEN start_date_active AND NVL(end_date_active, p_payroll_date)
610: AND business_group_id=p_business_group_id
611: and set_of_books_id=p_set_of_books_id
612: AND EXISTS
613: (SELECT '1' from psp_auto_rules where acct_id=a.acct_id)
614: ORDER BY acct_seq_num;
615:
616: CURSOR na_accts_c(p_period_type in VARCHAR2) IS
617: SELECT acct_id,segment_num, natural_account,

Line 627: (SELECT '1' from psp_auto_rules where acct_id=a.acct_id)

623: and business_group_id=p_business_group_id
624: and set_of_books_id=p_set_of_books_id
625: AND p_payroll_date BETWEEN start_date_active AND NVL(end_date_active, p_payroll_date)
626: AND EXISTS
627: (SELECT '1' from psp_auto_rules where acct_id=a.acct_id)
628: ORDER BY acct_seq_num;
629:
630: CURSOR params_c(p_acct_id IN NUMBER) IS
631: SELECT a.param_line_num, a.lookup_id,

Line 641: FROM psp_auto_rules

637: lookup_id=a.lookup_id);
638:
639: CURSOR rules_c(p_acct_id IN NUMBER) IS
640: SELECT calculator_rule
641: FROM psp_auto_rules
642: WHERE acct_id = p_acct_id;
643:
644: CURSOR by_pass_c IS
645: SELECT expenditure_type