DBA Data[Home] [Help]

APPS.PAY_SLA_PKG dependencies on XLA_CONDITIONS_T

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

734: -- Procedure to create custom ADRs based on their existing PAY-GL flex map
735: -- Creates a rule (in xla_rules_t) per Chart of Accounts Segment
736: -- Creates a rule detail (in xla_rule_details_t) for each Payroll Segment
737: -- mapped to this COA Segment
738: -- Creats 1 condition (in xla_conditions_t) for each rule detail
739: -- specifying the Payroll name
740: --
741: PROCEDURE create_custom_adrs
742: IS

Line 866: xla_conditions_t xc

862: from dual
863: where not exists
864: (select 1
865: from xla_rule_details_t xrd,
866: xla_conditions_t xc
867: where xrd.application_id = 801
868: and xrd.segment_rule_code = l_segment_rule_code
869: and xrd.value_source_code = l_pay_segment
870: and xc.segment_rule_detail_id = xrd.segment_rule_detail_id

Line 877: insert into xla_conditions_t (

873: -- create the condition if a rule detail was created
874:
875: if SQL%ROWCOUNT > 0 then
876:
877: insert into xla_conditions_t (
878: condition_id,
879: application_id,
880: amb_context_code,
881: segment_rule_detail_id,

Line 907: xla_conditions_t xc

903: from dual
904: where not exists
905: (select 1
906: from xla_rule_details_t xrd,
907: xla_conditions_t xc
908: where xrd.application_id = 801
909: and xrd.segment_rule_code = l_segment_rule_code
910: and xrd.value_source_code = l_pay_segment
911: and xc.segment_rule_detail_id = xrd.segment_rule_detail_id