APPS.PAY_LOAD_PROCESS_FLOWS dependencies on PAY_PROCESS_FLOWS

Line 462: -- Procedure used to upload seed data for the table PAY_PROCESS_FLOWS

458: -- |---------------------------< load_process_flows >--------------------------|
459: -- ----------------------------------------------------------------------------
460: --
461: -- Description:
462: -- Procedure used to upload seed data for the table PAY_PROCESS_FLOWS
463: --
464: -- ----------------------------------------------------------------------------
465: procedure load_process_flows
466: ( p_flow_name in varchar2

Line 476: from pay_process_flows ppf,

472: ) AS
473:
474: cursor ppfexists(p_flow_name varchar2) is
475: select ppf.process_flow_id
476: from pay_process_flows ppf,
477: pay_parameter_sets pps,
478: pay_parameters pp,
479: pay_parameter_definitions ppd,
480: per_business_groups pbg

Line 524: UPDATE PAY_PROCESS_FLOWS SET

520: end if;
521: --
522: if(found = TRUE) then
523:
524: UPDATE PAY_PROCESS_FLOWS SET
525: initialization_procedure = p_init_proc
526: ,description = p_desc
527: ,LAST_UPDATED_BY = decode(p_owner,'SEED',1,0)
528: ,LAST_UPDATE_DATE = SYSDATE

Line 538: INSERT INTO PAY_PROCESS_FLOWS (

534: OPEN c_get_set_id(p_flow_name);
535: FETCH c_get_set_id into l_set_id;
536: CLOSE c_get_set_id;
537:
538: INSERT INTO PAY_PROCESS_FLOWS (
539: process_flow_id
540: , set_id
541: , description
542: , initialization_procedure

Line 551: PAY_PROCESS_FLOWS_S.nextval

547: ,LAST_UPDATE_LOGIN
548: ,CREATION_DATE
549: ,CREATED_BY )
550: VALUES (
551: PAY_PROCESS_FLOWS_S.nextval
552: , l_set_id
553: , p_desc
554: , p_init_proc
555: , l_business_group_id

Line 594: pay_process_flows ppf,

590: cursor pfsexists( p_flow_name varchar2
591: ,p_set_name varchar2) is
592: select pfs.process_flow_set_id
593: from pay_process_flow_sets pfs,
594: pay_process_flows ppf,
595: pay_parameter_sets pps1,
596: pay_parameter_sets pps2,
597: pay_parameters pp1,
598: pay_parameters pp2,

Line 617: from pay_process_flows ppf,

613: and nvl(pfs.legislation_code,'CORE') = nvl(p_leg_code,'CORE');
614:
615: cursor c_get_flow_id ( p_flow_name in varchar2 ) IS
616: select ppf.process_flow_id
617: from pay_process_flows ppf,
618: pay_parameter_sets pps,
619: PAY_PARAMETERS pp,
620: PAY_PARAMETER_DEFINITIONS ppd
621: where ppd.parameter_name = p_flow_name