DBA Data[Home] [Help]

APPS.PAY_SLA_PKG dependencies on XLA_CONDITIONS_T

Line 757: -- Creats 1 condition (in xla_conditions_t) for each rule detail

753: -- Procedure to create custom ADRs based on their existing PAY-GL flex map
754: -- Creates a rule (in xla_rules_t) per Chart of Accounts Segment
755: -- Creates a rule detail (in xla_rule_details_t) for each Payroll Segment
756: -- mapped to this COA Segment
757: -- Creats 1 condition (in xla_conditions_t) for each rule detail
758: -- specifying the Payroll name
759: --
760: PROCEDURE create_custom_adrs
761: IS

Line 885: xla_conditions_t xc

881: from dual
882: where not exists
883: (select 1
884: from xla_rule_details_t xrd,
885: xla_conditions_t xc
886: where xrd.application_id = 801
887: and xrd.segment_rule_code = l_segment_rule_code
888: and xrd.value_source_code = l_pay_segment
889: and xc.segment_rule_detail_id = xrd.segment_rule_detail_id

Line 896: insert into xla_conditions_t (

892: -- create the condition if a rule detail was created
893:
894: if SQL%ROWCOUNT > 0 then
895:
896: insert into xla_conditions_t (
897: condition_id,
898: application_id,
899: amb_context_code,
900: segment_rule_detail_id,

Line 926: xla_conditions_t xc

922: from dual
923: where not exists
924: (select 1
925: from xla_rule_details_t xrd,
926: xla_conditions_t xc
927: where xrd.application_id = 801
928: and xrd.segment_rule_code = l_segment_rule_code
929: and xrd.value_source_code = l_pay_segment
930: and xc.segment_rule_detail_id = xrd.segment_rule_detail_id